Duplicates

D

Denise B

I have a sheet where dates are my column names and the
data is a bunch of codes. I would like to see if there
are any duplicate codes in the entire sheet as well within
the day. Is this possible?

Thank you,

Denise
 
M

Myrna Larson

Let's say the original data is in A1:F100 with headers in row 1

Starting in, say, G2, select cells G2:L100 and in G2 type the formula
=COUNTIF($A$2:$F$100,A2). Press CTRL+ENTER to enter it in all selected cells.
Those cells that contain a number > 1 are duplicated.
 
Top