Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to avoid duplicates in excel workbook? | Excel Discussion (Misc queries) | |||
massaging duplicates | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
How to count matching text | Excel Discussion (Misc queries) |