Duplicates

[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

 

[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.