Make unique cells - Avoid repeating Values

[Guest]

Hi,
Can someone please advise if there is any way to keep cells unique in
excelll? I have to input data on a large spreadsheet but I don’t want to
repeat the same values again. Is there any way to do that?

 

[Ken Wright]

Data / Validation.

Assume range A1:A30, highlight range, do data / validation, change 'any
value' to custom and put in the following formula:-

=COUNTIF($A$1:$A$30,A1)<2

Now hit Ok until out.

Note though that DV is easily bypassed by simply copying and pasting into
the range.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------