Hi everyone
I'm Paul - I work for a international mailing company and i need (desperately now) to find a formula that will sort two columns of data - the formula has to be Xcelsius friendly - so no macros and no ROW
I have a list of locations/units in column A and a their corresponding mail volumes in column B
I need to be able to sort the units in order of mail volume magnitude - i.e. those with the largest mail volumes at the top - this is to drive a Pareto chat in Xcelsius
Did i mention i have to have this ready and working by close of play Monday?
Arrrrrrrrrrrrrrrgh!
I would be eternally grateful for any help
PBM
I'm Paul - I work for a international mailing company and i need (desperately now) to find a formula that will sort two columns of data - the formula has to be Xcelsius friendly - so no macros and no ROW
I have a list of locations/units in column A and a their corresponding mail volumes in column B
I need to be able to sort the units in order of mail volume magnitude - i.e. those with the largest mail volumes at the top - this is to drive a Pareto chat in Xcelsius
Did i mention i have to have this ready and working by close of play Monday?
Arrrrrrrrrrrrrrrgh!
I would be eternally grateful for any help
PBM