=SUMPRODUCT(--(C2 < SUBTOTAL(9,OFFSET($C$2,ROW($C$2:$C$10000)-ROW($C$2),0))))+1
QUOTE]
Hi,
Seems like now I'm bringing this back from the dead....
This formula has worked perfect for my needs, but Im trying to reverse the RANK.... I have tried this "=SUMPRODUCT(--(C2 < SUBTOTAL(9,OFFSET($C$2,ROW($C$2:$C$10000)-ROW($C$2),1))))+1" but get an error.... any advice?
Thanks
Steve