I would insert another column (use a header of All) and then put this formula in
H2 (your data went to column G):

=SUBSTITUTE(TRIM(IF(B2<"","",$B$1)&" "
&IF(C2<"","",$C$1)&" "
&IF(D2<"","",$D$1)&" "
&IF(E2<"","",$E$1)&" "
&IF(F2<"","",$F$1)&" "
&IF(G2<"","",$G$1))," ",
"--")

Then I could apply Data|filter|autofilter to that column and show the
non-blanks.



via135 wrote:

hi!

i am having a2:a12 names; b1:g1 months; b2:g12 flags ("y" for reports
received, "blank" for not received)
is there any easy way to find out the names who have defaulted in
sending reports and the months of default
in a single report..?

NAME Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09
A Y Y Y Y
B Y Y Y
C Y Y Y Y
D Y Y Y Y Y Y
E Y Y Y
F Y Y Y Y
G Y
H Y Y Y Y Y
I Y Y Y Y
J Y Y Y Y Y
K

-via135

--

Dave Peterson