Data Validation
 

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

Data Validation
 

It just says that whatever is entered in A1 cannot appear in the area more
than one time.
--
Gary''s Student - gsnu200801


"Louise" wrote:

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

Data Validation
 

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.

"Gary''s Student" wrote:

It just says that whatever is entered in A1 cannot appear in the area more
than one time.
--
Gary''s Student - gsnu200801


"Louise" wrote:

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

Data Validation
 

You can apply the validation to only a single cell, but reference other cells
in the sheet.
--
Gary''s Student - gsnu200801


"Louise" wrote:

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.

"Gary''s Student" wrote:

It just says that whatever is entered in A1 cannot appear in the area more
than one time.
--
Gary''s Student - gsnu200801


"Louise" wrote:

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