ranking array query

[jaimetimbrell]

Hello,

I have data arranged like this:

col A.....................K.........T.................Z...AA...AB...AC etc
.........................................................(summary table)
..data data data score data 1.................summary event 1
..data data data score data 1.................summary event 2
..data data data score data 1.................summary event 3
..data data data score data 1

..data data data score data 2
..data data data score data 2
..data data data score data 2

..data data data score data 3
..etc for about 3000 rows

column K contains scores, in no particular order, as they were recorded
column T contains numbers to denote each separate array, each array is a separate event

I want to rank the score of a particular competitor in a summary table off to
the right somewhere

In the summary table column Z contains a score extracted based upon a set of criteria, I want to look at that score in the event that it came from and rank that score according to the other scores for that discrete event.

and so I have used the following formula, this is an example from cell AA3:

=RANK(Z3,IF($T$3:$T$2103=ROWS($A$3:$A3),$K$3:$K$2103),0)

all I get is #VALUE! and i dont know why...

I hope that is enough detail - can anyone help me understand why it doesnt work?

Regards,
Jaime.

 

[jaimetimbrell]

...was hoping someone could help me with the above - or tell me that I was trying to achieve something possible...

Would be grateful for any views?

Regards,
Jaime.