Remove Duplication from Validation List?
See reply in .Functions
Biff
wrote in message
ups.com...
Hi. I want to use a range of cells, all in part of a column, as a
validation list source. Here's the formula I have for the validation
list source in the cells where the validation list should be applied:
=(OFFSET(RangeStart,1,0)):(OFFSET(RangeEnd,-1,0))
The problem I'm having is that if duplicate values exist between
RangeStart and RangeEnd, I get duplicate values in my validation list.
How could I eliminate duplication from the displayed pulldown
validation list?
Thanks for any input!
Ken
|