Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
Web Query Help... | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |