Make unique cells - Avoid repeating Values
 

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 dont want to
repeat the same values again. Is there any way to do that?

Make unique cells - Avoid repeating Values
 

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 :-)
------------------------------*------------------------------*----------------


"Mary" wrote in message
...
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?