View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
oscar oscar is offline
external usenet poster
 
Posts: 55
Default Data Validation - List of unique values

Is it possible to get list of unique values for data validation. In range a2
- a10 that I use as data validation list i have values x, y, z, x, x, ... In
a drop down I get letter x listed more than one time. Is it possible to make
it unique? I use Excel 2003.

Thanks.