how do i filter non blanks across 5 columns at 1 time?

[Max]

Assume source cols are cols A to E, data from row2 down
In F2: =IF(COUNTIF(A2:E2,"<>"),"x","")
Copy down to last row of source data
Apply autofilter on col F, choose: x
to get the exact results that you seek

P/s: You should never leave the message area blank. Use it to elaborate
further on your query. The subject line is just that, it's not meant to be
the posting!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik[/QUOTE]

Re: how do i filter non blanks across 5 columns at 1 time?

 

[mm]

thank you very much, it works! will take note to elaborate in message box in
future.

Assume source cols are cols A to E, data from row2 down
In F2: =IF(COUNTIF(A2:E2,"<>"),"x","")
Copy down to last row of source data
Apply autofilter on col F, choose: x
to get the exact results that you seek

P/s: You should never leave the message area blank. Use it to elaborate
further on your query. The subject line is just that, it's not meant to be
the posting!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik

Re: how do i filter non blanks across 5 columns at 1 time?
[/QUOTE]

 

[Max]

Welcome, and thanks for feeding back.