Pages

Search

Excel Help Forum - Excel General: How to delete rows if column A1 and B1 are equal to A2 and B2

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to delete rows if column A1 and B1 are equal to A2 and B2
Hey guys, How do you automatically delete all rows EXCEPT ONE when for example A1,B1,C1,D1 are equal to A2,B2,C2,D2 AND copy the remaining one to another sheet if column E is greater then 4 999 999.99$? For example: A B C D E 1| 13232 | 250 | 1800...