Thread: ranking query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JaimeTimbrell
 
Posts: n/a
Default 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.