Duplicates
 

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

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