Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
limit range to unique values
I am looking for a way to limit a named range to unique values. So
that if a value is entered that already exists in the range the value that already exists would become empty and the new location would hold the unique value. I got something sort of working with the selection change event but it took too long to cycle through each cell in the range to make sure it did not equal the target value. was not pretty. The range is only like 50 cells. I am looking for advise on how to make it work. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating the number of unique values with a range | Excel Discussion (Misc queries) | |||
Unique values from date range | Excel Discussion (Misc queries) | |||
How do I get the unique values from a range? | Excel Worksheet Functions | |||
Sum Unique Values Across SpecialCellType Visible Range. | Excel Programming | |||
Display unique values in a range. | Excel Programming |