Cell Filtering

  • Thread starter Thread starter PaolaAndrea
  • Start date Start date
P

PaolaAndrea

I have a spreedsheet with several rows that I would like
to filter. How can I entered a formula that will hide
the empty rows.

Sample Data:

Date Name1 Name2 Name 3
June 5 8 8 9
June 6
June 7 8 8 8

I want to enter a query that will hide June 6, since
there is no info for that date.

Please advise.

Thank you
 
You cannot use a formula to hide rows.

Formulas can only return values to the cell(s) in which they reside.

You must use Data>Filter or VBA.

Gord Dibben Excel MVP
 
Back
Top