Hi I'm new to excel i have a league table I input scores the table updates but I have to use the sort function. e.g. Sort by Column B, then by Column C, then by Column E and the table is put in order highest to lowest Is there a formula to do this automatically??:confused:

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

sorting formulas

Thread starter webby180
Start date May 26, 2011

webby180

New Member

May 26, 2011

Hi

I'm new to excel i have a league table
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
I input scores the table updates but I have to use the sort function. <o

></o

>
e.g. Sort by Column B, then by Column C, then by Column E and the table is put in order highest to lowest

Is there a formula to do this automatically??