View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jedale@gmail.com is offline
external usenet poster
 
Posts: 16
Default Setting up a validation of data listbox to provide the unique items within a range

That would be really helpful if it's not to much to ask.

The FALSE attributes are coming from the function returning no more
unique entries. I could just limit the function by filling down to the
last unique entry, but this wouldn't allow for any future expansion on
my lists. Consequently, I would have to manually go through the and
check the lists from time to time to make sure the function is
returning all known unique items by filling down cells. I was just
wondering if there was a way to hide the FALSE attribute from showing
up in the list once all unique entries are given so that they wouldn't
be in the validation of data select box.

Thanks again,
Jeff