View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
irvine79 irvine79 is offline
external usenet poster
 
Posts: 21
Default Eliminate duplicate values in drop down list

I am creating a drop down list based on a "Month" column in my data. ie. this
line item is associated with January, this line with March etc. The problem
is that I have several lines for each month. Is it possible to create a drop
down list that will only list each month once based upon the "Month" column
in my data?

Thanks!