View Single Post
  #6   Report Post  
Paul Moore
 
Posts: n/a
Default


Found them Nick. Brilliant!!

Thanks again, Paul

--

--
paul<dotmoore@pandora<dotbe
Adjust "dots" for real address
"Nick Hodge" wrote in message
...
Paul

If you look at the bottom of the autofilter drop-down, you have the
options 'Blanks' and 'Non-Blanks' (If they exist)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Paul Moore" wrote in message
...

Nick and Earl,

Many thanks for your help ( and the very quick response!)

A further question: Is it possible to filter such that only rows
containing a blank cell are displayed? I suppose I want to do something
like

Include row if ISBLANK(M7:M300)

Thanks again,
Paul