ranking query
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$21 03),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.
|