software

Hi. I want to use a range of cells, all in part of a column, as a
validation list source. Here's the command I have in the cells to
which I want to apply the validation list source:

=(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!

KenYou'd have to create a new source without the dupes. There's no way to
remove dupes from the validation list itself.

Biff

gt; wrote in message oups.com...
gt; Hi. I want to use a range of cells, all in part of a column, as a
gt; validation list source. Here's the command I have in the cells to
gt; which I want to apply the validation list source:
gt;
gt; =(OFFSET(RangeStart,1,0))OFFSET(RangeEnd,-1,0))
gt;
gt; The problem I'm having is that if duplicate values exist between
gt; RangeStart and RangeEnd, I get duplicate values in my validation list.
gt; How could I eliminate duplication from the displayed pulldown
gt; validation list?
gt;
gt; Thanks for any input!
gt;
gt; Ken
gt;