ranking query

[Guest]

I would like to rank a value in a column of values using RANK.

The complication is that I have a lot of data all arranged into discrete
arrays:

data data data data data 1
data data data data data 1
data data data data data 1
data data data data data 1

data data data data data 2
data data data data data 2
data data data data data 2

I have put the numbers at the end of each array so I can pick each array out
discretely

and so I have used the following formula:

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

Z3 - is the value I want to rank
IF($T$3:$T$2103=ROWS($A$3:$A3),$K$3:$K$2103) - is a statement I have used to
pick out each discrete array within the complete spreadsheet full of arrays

But it doesnt work, can anyone see any reasons shy it wouldnt work?

I would be most grateful for anyones advice.

Regards,
Jaime.

 

[Pete_UK]

I can't quite see what it is you want to do, relating to your example,
but I think you will need to use the INDIRECT( ) function once you have
selected the appropriate range.

Hope this helps.

Pete

 

[Guest]

Hi Pete,

Thanks for getting back to me.

I think it is selecting the appropriate range that is the problem, if I
explain my problem in more detail that may help:

I have data arranged like this:

col A.....................K.........T.................Z...AA...AB...AC etc
...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 <rank score of this one

...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 array, each array is a separate event

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

in teh summary table column Z contains a score extracted based upon a set of
criteria, that are unrelated to twhere the competitors score ranks in the
scores for each event

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:

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

I hope that explains it in more detail.

Regards,
Jaime.