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
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