I have this file where I have defined a range for dropdown i.e. column A. That data is required as dropdown in column F under the heading input. The issue I am facing is in the dropdown I could see those many number of times the data being repeated as much as it is present in column A. i.e. the title "Environment" repeats 9 times in column A and hence shows equal number of times in column F. Is there a way to eliminate these repetitions, still get the dropdown of entire range of data ?
id attack it like this if you are going to add to end of list.
or you could just use advanced filter to extract an unique list instead
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
tanksalevikrant 
Register To Reply
Bookmarks