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?