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
No attachmen5t.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
oops sorry... please see it now
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
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
