View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Filtering Multiple Columns...

ouch ... that hurt!

Bob

"Max" wrote in message
...
=COUNTIF(A2:G2,"N")0


Believe Bob meant:
=COUNTIF(E2:G2,"N")0

(Aha, gotcha Bob ! <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote in message
...
I would just use

=COUNTIF(A2:G2,"N")0

and filter on TRUE <g

--
HTH

Bob