Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a range of data in cells A1:K1000 and some of the row data in that
range has been partially duplicated. What I would like to do is to delete the duplicated row if the cell values in column A are the same as well as the data in Column E. For example: If cell A1 (Smith) and A2 (Smith) are the same and cells E1 (Microsoft) and E2 (Microsoft) are the same, delete row 2. However If cell A1 (Smith) and A2 (Smith) are the same and cells E1 (Microsoft) and E2 (Apple) are different, then this is not a duplicate so it should not be deleted. Any assistance would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Duplicated Data by Cell | Excel Discussion (Misc queries) | |||
Compare multiple rows for duplicated values in individual columns | Excel Worksheet Functions | |||
Deleting rows based on data NOT meeting criteria --working macro here, just need help with tweaking | Excel Programming | |||
Deleting Rows with data duplicated in 2 columns | Excel Worksheet Functions | |||
Comparing columns and deleting rows based on criteria | Excel Programming |