Thread: Data validation, select from list: omit blanks?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George[_3_] George[_3_] is offline
external usenet poster
  
Posts: 14
Default Data validation, select from list: omit blanks?
I'm using <data - validation - allow "list". Which works fine, except
this particular list has blank cells interspersed within it. Is there a
way to have the list ignore the blanks?

TIA,
George
Reply With QuoteReply With Quote