Unique numbers entered once only
Yes, I see. Thank you!
James
"Mike H" wrote in message
...
Hi
What it does in A1 is check whether the same value appears elsewhere in
column A but because the whole column is selected when the formula is
entered
and because A1 isn't absolute it increments for each cell so the A2
formula
becomes
=COUNTIF($A:$A,A2)<2
This checks if the value in A2 appears in AA on so on. Got it?
Mike
"Zone" wrote:
Could I barge in to ask a question on this? Mike, this works great.
Could
you explain how this formula works in Data Validation? I don't get the
A1
part. Thanks! James
"Mike H" wrote in message
...
Hi,
Select column A and then
Data|validation
Select custom and enter this formula
=COUNTIF($A:$A,A1)<2
Mike
"Malcolm McMaster" wrote:
I am having a problem with a client using Excel to record receipts
issued
to her clients.
Looking at the data she has entered it appears that she has entered
some
receipts twice. Is there any way one can enforce unique integrity on a
data
column so that if the operator tries to enter the same number it will
be
rejected or ring warning bells ? If you can offer any suggestions it
would be
much appreciated.
|