Thread: How do I highlight duplicate data on a spreadsheet?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I highlight duplicate data on a spreadsheet?
See Chip Pearson's site for working with and highlighting duplicates.

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


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 07:46:01 -0800, Grim72
wrote:

I have a column of data on an Excel spreadsheet that should be unique codes.
I want to highlight any cells that contain duplicated data. Any idea how to
do this?

Reply With QuoteReply With Quote