Forum Discussion
Filtering
Is there a way to filter a list by the value of the 1st row? I want to make so if row 1 is blank that list doesn't appear. Example
A1="", A2=3,B1=Yes,B2=4.
In this case A1 and A2 would be filtered out because A1 is blank.
A1="", A2=3,B1=Yes,B2=4.
In this case A1 and A2 would be filtered out because A1 is blank.
1 Reply
Hi Thomas,
You may use Advanced Filter but for it in the first row shall be names of your columns and data starts from second row. Entire list (all columns) will be hided except names row (i.e. B1, B2 etc in your sample will be hided as well).
How it works https://support.microsoft.com/en-ie/help/2720580/using-advanced-filters-in-excel-2010, your criteria could be
=NOT(ISBLANK($A$2))
