• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

!!! HELP ME!!! Auto Sort - (without using ROW or any Macros)

PBM

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

Hui

Excel Ninja
Staff member
PBM

Change the Data to A Table

- Excel 2007, Insert table

Click on the Drop Down in the column you want and select Sort
 

Hui

Excel Ninja
Staff member
and PBM, no need for the !!! HELP ME !!!

We try to help everyone anyway.
 
Top