View Single Post
  #5   Report Post  
Nick Hodge
 
Posts: n/a
Default

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