Discussion Locked

How to find duplicate item in one column

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

5 replies

by sgt_shultz

only thing i can think of is macro that copies column to new column cell by cell, first checking to see if value already exists in new column if yes discarding...

by dklippert

Of course, you would select the A column and the go to Format Conditional Format. Change the selection to "Formula" enter the equation and change the formatting options.

This discussion is closed to new replies.