Remove Duplication from Validation List?

K

kk_oop

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove duplication from validation list? 1
Validation list question 3
Question about validation lists 3
Data Validation List (Drop Down) Not Showing 2
Data Validation List with blanks 1
Data Validation /w Duplicate Entries 3
Offset Named range in Datavalidation List 4
Data Validation - Restriction 7

Top