Identifying Identical Cells

  • Thread starter Thread starter Carl Gilbert
  • Start date Start date
C

Carl Gilbert

I am looking for a way to determine if there is any duplication of
data within a worksheet.

For example if you had a list of songs spread across 4 columns and 20
rows, is there a way to display text in another cell should any cell
between A1:D20 be identical to the same range of cells?

Many thanks, Carl Gilbert.
 
Try Conditional Formatting,,
Select cell A1, then Highlight A1:D20, Click on Menu Format, then CF
then select

Formula IS In Box enter =COUNTIF($A$1:$D$20,A1)>1
then Format Button, select a color pattern, then OK, OK

Any duplicates should show in your selected color..
 
Back
Top