View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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?