Posted to microsoft.public.excel.misc
|
|
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
|