Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate check
Hi I am making a spreadsheet where I am inputting a large list of different numbers - I want to put a check in to make sure no number is input more than once. What would be the easiest way to do this? (ideally a column to the right of the number could be used to flag up where there is a duplicate number) Thanks -- rufusf |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate check
Try this in that 'helper' column to the "right" that you mentioned:
=IF(AND(A1,COUNTIF($A$1:A1,A1)1),"Duplicate","") And copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "rufusf" wrote in message ... Hi I am making a spreadsheet where I am inputting a large list of different numbers - I want to put a check in to make sure no number is input more than once. What would be the easiest way to do this? (ideally a column to the right of the number could be used to flag up where there is a duplicate number) Thanks -- rufusf |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate check
Don't know why I put the "AND" in there!
Try this: =IF(COUNTIF($A$1:A1,A1)1,"Duplicate","") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "RagDyeR" wrote in message ... Try this in that 'helper' column to the "right" that you mentioned: =IF(AND(A1,COUNTIF($A$1:A1,A1)1),"Duplicate","") And copy down as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "rufusf" wrote in message ... Hi I am making a spreadsheet where I am inputting a large list of different numbers - I want to put a check in to make sure no number is input more than once. What would be the easiest way to do this? (ideally a column to the right of the number could be used to flag up where there is a duplicate number) Thanks -- rufusf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Visual basic Check Box and the IF formula | Excel Discussion (Misc queries) | |||
Check for duplicate data | Excel Worksheet Functions | |||
Formula for duplicate entries? | Excel Discussion (Misc queries) | |||
How can I check for duplicate $'s? | Excel Worksheet Functions |