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

1. Put your data table at A25:D34.

2. Copy your names to A15:A23.

3. Copy this formula to B15 and then copy it to B15:B23.

=--(((MAX(B$26:B$34)-MIN(B$26:B$34)))-((MAX(B$26:B$34)-MIN(B$26:B$34)))/3<B26)

4. Copy your names to A3:A11.

5. Copy this to B2 and then copy it to B2:B11.

=B15


6. Copy this to C2 and then copy it to C2:D11.

=IF(AND(B2=1,C15=1),B2+C15,C15)

If I've guessed at the correct definition of "Top 33%" this should work.

HTH
Jim

"A.C.G." wrote:

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