Thread: validation list with no duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rodrigo Ferreira Rodrigo Ferreira is offline
external usenet poster
  
Posts: 79
Default validation list with no duplicates
Hi,
How can I create a validation list with no duplicates?
I have the list:

A
ABC
DEF
GHI
ABC
DEF
ZXC
....

On B3 I want a validation list with:
ABC
DEF
GHI
ZXC

How can I do this?

--

Rodrigo Ferreira



Reply With QuoteReply With Quote