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

  • Thread starter Thread starter mm
  • Start date Start date
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!
[/QUOTE]

Re: 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 said:
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!
Click to expand...

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