General discussion
February 29, 2004 at 08:40 PM
hunterzh

How to find duplicate item in one column

by hunterzh . Updated 22 years, 6 months ago

How to find duplicate items in one column?

In Excel 2000, we have one column with many item codes; now I hope to find out duplicate codes, changing its font color to red. How can I realize this, but not using “sort”?
I thought to use “match”, like MATCH(A10,$A$1:$A$1000,0), but how to exclude the cell itself?

This discussion is locked

All Comments