PDA

View Full Version : Solved: Help - Ranking Cells in non-continuous range



agnesz
01-03-2008, 09:33 AM
I need to figure out a formula which will rank an element that is part of a range per se, but not in a continous range. I'm attaching a sample spreadsheet to explain what I mean.

BAsically I want to rank Division 1's Sales $ for This Year and Plan against the other 2 divisions, however the other Sales are figures are not in cells next to each other.

Hope this makes sense. I appreciate any help.
tx

xld
01-03-2008, 10:11 AM
No attachmen5t.

agnesz
01-03-2008, 12:19 PM
oops sorry... please see it now

xld
01-03-2008, 01:29 PM
Okay that is an easy one

C5: =RANK(B5,(B$5:B$11,G$5:G$11,I$5:I$11))

E5: =RANK(D5,(D$5:D$11,H$5:H$11,J$5:J$11))

copy down