How to find duplicate items and delete one (row)?
In Excel 2000, we have one column with many items, some are duplicate. Now I can find duplicate items by using COUNTIF function. But there are so many items, over two thousand, with hundreds of duplicate items. I hope to delete one row (with larger address number) which has duplicated item.
How can I delete duplicate items quickly? By using a function, macro?
For example, cell B18 and B6 have duplicate items, now I want to delete row 18.
Thanks for the answer from DKlippert, but I need to delete the complete row which has the duplicate item. Only filtering cannot solve this problem.
Use Data>Filter Advanced filter
Select the column
Choose the Copy to another location option
Enter the first cell of a target range
Put a check mark in Unique records only
DKlippert