A
agrandstaff
Ok. I need to have a formula which would look at a number of columns
and tell me now many 'consecutive' months someone has been in the top
33% of the numbers in that column to date. IE . . .Ann was in the top
33% in Jan and Feb but not in March so in March I would want the
formula to spit out '2', In April I would want it to start over again
at '1' (If in fact she was in the top 33% in March, if not then it
should say '0'). Hardest part in figuring this out (in my head anyway)
is how to get it to give me the number as of the current date. Figures
=NON() would have to be in there somewhere but not sure how. Hope I
explained all that properly.
JAN FEB MAR
Jane 34.5 44.6 77.8
Bob 22.3 12.5 34.6
Bill 32.6 87.7 44.4
Jill 44.3 66.5 34.8
Ann 87.6 55.2 15.6
Eric 74.5 33.3 13.8
Jim 44.7 22.8 22.3
Lisa 56.4 55.4 55.9
Sam 67.1 64.8 70.0
and tell me now many 'consecutive' months someone has been in the top
33% of the numbers in that column to date. IE . . .Ann was in the top
33% in Jan and Feb but not in March so in March I would want the
formula to spit out '2', In April I would want it to start over again
at '1' (If in fact she was in the top 33% in March, if not then it
should say '0'). Hardest part in figuring this out (in my head anyway)
is how to get it to give me the number as of the current date. Figures
=NON() would have to be in there somewhere but not sure how. Hope I
explained all that properly.
JAN FEB MAR
Jane 34.5 44.6 77.8
Bob 22.3 12.5 34.6
Bill 32.6 87.7 44.4
Jill 44.3 66.5 34.8
Ann 87.6 55.2 15.6
Eric 74.5 33.3 13.8
Jim 44.7 22.8 22.3
Lisa 56.4 55.4 55.9
Sam 67.1 64.8 70.0