Duplicate Items In A Spreadsheet
Posted by Debbie Lewandowski on January 15, 2002 1:38 PM
How do I get rid of duplicate items listed in a column?
I need to delete part numbers that are repeated in a very large file. Example: There may be two work orders for the same part number. How can I get rid of part numbers that are repeated?
This is a shared file, with different people entering data into the bottom of it. They don't know, or care for that matter, to see if the data they are entering already exists. They just enter the part number. Is there a way I can highlight the entire column and delete the repeats? Does that make sense to anyone?
This would save time and make my workload look smaller.
Thanks in advance!