| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to delete duplicates based on data in 2 columns?
Hello,
I have a 2 column spreadsheet. Column A contains a part number. Column B contains a country of origin. Column A may or may not contain duplicate part numbers and Column B may or may not contain a duplicate country of origin's. WS23403 USA WS23403 USA WS23600 MEXICO WS23600 USA WS23600 USA What I want to do is to get rid of those lines that are duplicates. In the example I'd want to get rid of the first line and the last line. I've played with countif but it really isnt useful in this case. Suggestions? Regards Max |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Delete row based on multiple columns of data | Excel Discussion (Misc queries) | |||
| How to delete a data row based on a condition | New Users to Excel | |||
| Finding duplicates based on 2 columns | Excel Worksheet Functions | |||
| entering data to overwrite and delete duplicates | Excel Discussion (Misc queries) | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
Threaded Mode
