Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicate serial #s
I want to create a spreadsheet that when a number is entered, it will state
whether that number is already in the spreadsheet or if it is not located. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicate serial #s
http://www.cpearson.com/excel/NoDupEntry.htm
-- Kind regards, Niek Otten Microsoft MVP - Excel "Dgwood90" wrote in message ... |I want to create a spreadsheet that when a number is entered, it will state | whether that number is already in the spreadsheet or if it is not located. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicate serial #s
How about using a helper column. If your serial#'s are in columnA in cell
B1 enter =IF(OR(A1="",COUNTIF(A:A,A1)<2),"","Dupe") and copy it down. It will show nothing if there is no entry in the corresponding cell in A or if it is not a dupe. If there is a dupe it will show Dupe in BOTH/ALL duplicated cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Dgwood90" wrote in message ... I want to create a spreadsheet that when a number is entered, it will state whether that number is already in the spreadsheet or if it is not located. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FINDING DUPLICATE TEXT IN 2 COLUMNS!!!!! | Excel Discussion (Misc queries) | |||
Finding Duplicate Phrases in a File | Excel Worksheet Functions | |||
finding & filtering out duplicate cells | Excel Discussion (Misc queries) | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
Finding duplicate records in Excel | Excel Discussion (Misc queries) |