Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions |