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.

On Mon, 17 Jan 2005 13:39:50 -0800, "Denise B"
wrote:

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