View Single Post
  #1   Report Post  
Jennifer
 
Posts: n/a
Default Duplicates in database validation

Hey all,
My database has duplicate invoice entries. This is good. Problem arrises on
another worksheet where I want to use these invoice numbers in a validation
drop box but I don't want to see
1
1
1
3
3
2
2
I would like to only see one of each invoice entry in the validation. Anyone
have any ideas. Thank you, Jennifer
--
Though daily learning, I LOVE EXCEL!
Jennifer