| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to delete duplicates based on data in 2 columns?
I'd use a helper column and concatenate the values:
=a1&"..."&b1 and drag down. Then use the techniques at Chip Pearson's site: http://www.cpearson.com/excel/Duplicates.aspx Max wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to delete duplicates based on data in 2 columns?
Thanks Dave... that did help. I also found that filtering for unique records
was helpful. Regards Max "Dave Peterson" wrote: I'd use a helper column and concatenate the values: =a1&"..."&b1 and drag down. Then use the techniques at Chip Pearson's site: http://www.cpearson.com/excel/Duplicates.aspx Max wrote: 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 -- Dave Peterson |
| Reply |
| 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) | |||
Linear Mode
