Thread: validation list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 515
Default validation list

Remove the duplicates?

--
HTH

Kassie

Replace xxx with hotmail


"Ruth" wrote:

Hi there

I have a worksheet that uses a validation list that has multiple entries of
the same thing, ei the validation list will have "Alpena" 4 or five times in
a row. I want each name just to show up once in the drop down box. Is that
possible, if so, how?


--
Thank-you!
Ruth