duplicate check

R

rufusf

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
 
R

RagDyeR

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!
=====================================================


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
 
R

RagDyeR

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!
=====================================================


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!
=====================================================


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
 
Top