Advanced Filter for NonBlanks

[knowshowrosegrows]

I have what I think is a simple question that I need answered IMMEDIATELY.

I have a spreadsheet with 20 fields and I want to filter it so it only shows
records that have something in one or any of 5 of those fields. So once
filtered, I will not have any records that have all 5 of those fields blank.

I know I have done this before but I'll be damned if I can remember or find
out how.

 

[Alexander Wolff]

Die Tastatur von knowshowrosegrows wurde wie folgt gedrückt:

I have what I think is a simple question that I need answered
IMMEDIATELY.

I have a spreadsheet with 20 fields and I want to filter it so it
only shows records that have something in one or any of 5 of those
fields. So once filtered, I will not have any records that have all
5 of those fields blank.

I know I have done this before but I'll be damned if I can remember
or find out how.

- Your data with included top fieldname line (for autofilter) in A1:H5
- Your 5 columns be B:C;E:G
- Append column I likewise (header ...) with formula =OR(B2:C2;E2:G2)
- copy down
- filter H1 for TRUE