Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for checking duplicate numbers
I have to record apt unit numbers in separate columns. I could up to 20 or 30
columns. My problem is apt unit numbers being entered multiple times. Is there something that can check for duplicate numbers and let me know? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for checking duplicate numbers
If the columns are in a contiguous block then it's fairly easy. If the
columns are scattered around the sheet then it could be complicated. -- Biff Microsoft Excel MVP "Ron" wrote in message ... I have to record apt unit numbers in separate columns. I could up to 20 or 30 columns. My problem is apt unit numbers being entered multiple times. Is there something that can check for duplicate numbers and let me know? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for checking duplicate numbers
If you simply want to identify where duplicates are, then use conditional formatting. Use the following formula for conditional formatting: =COUNTIF($A$1:$C$4,A1)1 The range $A1$1:$C$4 will have to be expanded to include the entire range where duplicate apartment numbers could exist. The cell A1 is the leftmost, topmost cell in this range, and the format can be duplicated to all cells in the range.
--- frmsrcurl: http://msgroups.net/microsoft.public...licate-numbers |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for checking duplicate numbers
Is the duplicates you are looking for in one column? If it is, I insert a
column next to it and use this formula. Just use the correct column letter you are searching for in the formula. =IF((COUNTIF($B:$B,$B2)1),"Duplicate("&COUNTIF($B :$B,$B2)&")","") "dflak" wrote: If you simply want to identify where duplicates are, then use conditional formatting. Use the following formula for conditional formatting: =COUNTIF($A$1:$C$4,A1)1 The range $A1$1:$C$4 will have to be expanded to include the entire range where duplicate apartment numbers could exist. The cell A1 is the leftmost, topmost cell in this range, and the format can be duplicated to all cells in the range. --- frmsrcurl: http://msgroups.net/microsoft.public...licate-numbers . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for checking duplicate entries | Excel Worksheet Functions | |||
Checking for duplicate entries | Excel Discussion (Misc queries) | |||
Checking for duplicate entries over multiple worksheets | Excel Discussion (Misc queries) | |||
Checking for duplicate records / rows | Excel Discussion (Misc queries) | |||
Checking for duplicate items in list | Excel Worksheet Functions |