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

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

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