Thread
:
Is it possible to use Autofilter, when column labels not in Row 1?
View Single Post
#
5
Nick Hodge
Posts: n/a
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
Reply With Quote