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
|