View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Monique
 
Posts: n/a
Default How do I use advanced filter to filter for blank cells?

I'm using Excel 2003 for a training database. I have a relatively large
spreadsheet (+50 columns of job titles and +550 rows of SOP's) with various
various data in the cells. Each row must contain data in at least one cell
other that A#. I need to find the rows that contain blank cells from column
B across through last column, so that I can find the gaps. I can't seem to
come up with the correct criteria for this.

Monique