Duplicates

Matt in AZ · Jun 9, 2004

I have a column of Numbers in column B. I need to a function or something that will make those numbers that are duplicates stand out, like highlight them in Red or put a mark next to them in the next column (c). I need to be able to see which ones are duplciates easily instead of sorting them and picking them out manually. I also need the originals highlighted too. If there are two number six's, I need both of them highlighted or marked. Thanks
-Mat

Dave Peterson · Jun 9, 2004

Chip Pearson has a bunch of techniques for working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

Matt in AZ · Jun 9, 2004

Thank you. That site is very helpful! =

----- Dave Peterson wrote: ----

Chip Pearson has a bunch of techniques for working with duplicates at
http://www.cpearson.com/excel/duplicat.ht

Matt in AZ wrote