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