[absthechatter]

Sorry, no. I'll try to give an example.

NAME SCORE RANK
Ann 100 1
Dave 95 2
Ann 45 5
Steve 65 4
Dave 40 6
Ann 89 3
Ann 15 7

Columns A,B and C as above, with C auto completing with a RANK formula. If I then filter column A to just Ann, it will show her ranks as 1, 5, 7 and 3. What I want it to do, is just rank Ann and ignore the rest, so it ranks 1, 2, 3, 4. If that makes sense!!???


Many thanks

Abs

---------- Post added at 15:23 ---------- Previous post was at 15:21 ----------

Not only can I not explain what I mean, I cannot get the formatting right either!!!

Abs