Say we have in cols A thru Y. We are interested in blanks. In Z2 enter:

=IF(COUNTIF(A2:Y2,"")=25,25,IF(COUNTIF(A2:Y2,"")=0 ,0,1)) and copy down

Set the AutoFilter for column Z.

To see which records are all blank, set the filter to 25
To see which records have no blanks, set the filter to 0
To see the records that have some blanks, set the filter to 1
--
Gary''s Student - gsnu200903


"confused_in_London" wrote:

I have a spreadsheet with several columns of data that I need to filter to
show blank cells. Is there a way to apply the autofilter to more than one
column to save me from filtering each individual column?
Thanks