Cell Filtering

[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

 

[Guest]

Hi

Use Data/Filter/AutoFilter. You can then filter this column to 'non-blanks'.
Have a look here for more info:
http://www.contextures.com/xlautofilter01.html

 

[Gord Dibben]

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