Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet that has in column A an account number and in column D
the another account number tied to the first. However, the report also has the tied account number from column D in column A and vice versa. I need to find the duplicate listing of accounts and remove one of the rows. Is there a formula that can do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Collapse rows with duplicates | Excel Worksheet Functions | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions | |||
Finding Duplicates | Excel Worksheet Functions | |||
Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) |