View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Advanced Filter (Criteria + Blanks)

Choose your first criteria (whatever you want)
Or
Equals
(and leave that second dropdown (on the right) completely empty.)

SamuelT wrote:

Thanks for those suggestions Bob.

Do you (or anyone) know how to state the (Blank) criteria when setting
a custom Autofilter?

Thanks,

Sam

--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=558451


--

Dave Peterson