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 of 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.

--
Thanks

You all are teaching me so much

Something like this in Z2, where Z1:Z2 is the criteria:
=OR(B2<"",F2<"",G2<"",H2<"",K2<"")

"knowshowrosegrows" wrote in
message ...
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 of 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.

--
Thanks

You all are teaching me so much

You can use autofilter to filter columns with 'nonblanks'.
--
Carrie


"knowshowrosegrows" wrote:

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 of 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.

--
Thanks

You all are teaching me so much