Data Validation

L

Louise

Hi all

Using the following formula in data validation will avoid the user entering
duplicate entries, however, I don't understand what the A1 is for.... can
anybody explain to me?

Thank you.

=countif($1:$65536,A1)<2
 
G

Gary''s Student

It just says that whatever is entered in A1 cannot appear in the area more
than one time.
 
L

Louise

but by highlighting the whole worksheet to begin with, the rule has been
applied to every cell any way, not just A1.

Does that make sense??

Thanks, Louise.
 
G

Gary''s Student

You can apply the validation to only a single cell, but reference other cells
in the sheet.
 
Top