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

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

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


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

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

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

"Max" wrote:

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


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

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

Welcome, and thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mm" wrote:
thank you very much, it works!
will take note to elaborate in message box in future.