View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How to highlight duplicate entries?

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kimbor" wrote in message ...
| Howdy! I have a large, but simple, database list consisting of three columns
| -- first name, last name, email -- that I've sorted by last name. I'm
| looking for a formula that will find the duplicates and highlight them for
| me. It sounds simple, but I just can't figure it out. Anyone? Thanks!