Auto Sorting a group of cells highest to lowest

[Yoti14]

Ok, last question for tonight This one is about how to Auto sort a group of cells highest to lowest, by using a formula. is this even doable?

Below is a list I need to auto sort. I'd like to sort it by Scale Speed, fastest to slowest


AL AM AN AO AP AQ AR AS AT AU
[TABLE="width: 514"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="align: center"] Car#[/TD]
[TD="align: center"]Car Make[/TD]
[TD="align: center"]Lane 1[/TD]
[TD="align: center"]Lane 2[/TD]
[TD="align: center"]Lane 3[/TD]
[TD="align: center"]Lane4[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]Totals[/TD]
[TD="align: center"]Scale Speed[/TD]
[TD="align: center"]Qual Pos.[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]Intrepid[/TD]
[TD="align: center"]1.210[/TD]
[TD="align: center"]1.213[/TD]
[TD="align: center"]1.345[/TD]
[TD="align: center"]1.100[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]4.868[/TD]
[TD="align: center"]977.067[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.230[/TD]
[TD="align: center"]1.342[/TD]
[TD="align: center"]1.354[/TD]
[TD="align: center"]1.213[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]5.139[/TD]
[TD="align: center"]925.543[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.100[/TD]
[TD="align: center"]1.320[/TD]
[TD="align: center"]1.500[/TD]
[TD="align: center"]1.650[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]5.570[/TD]
[TD="align: center"]853.925[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.100[/TD]
[TD="align: center"]1.789[/TD]
[TD="align: center"]1.245[/TD]
[TD="align: center"]1.561[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]5.695[/TD]
[TD="align: center"]835.182[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.900[/TD]
[TD="align: center"]1.388[/TD]
[TD="align: center"]1.239[/TD]
[TD="align: center"]1.230[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]5.757[/TD]
[TD="align: center"]826.188[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.880[/TD]
[TD="align: center"]1.213[/TD]
[TD="align: center"]1.324[/TD]
[TD="align: center"]1.365[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]5.782[/TD]
[TD="align: center"]822.616[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.210[/TD]
[TD="align: center"]1.670[/TD]
[TD="align: center"]1.444[/TD]
[TD="align: center"]1.781[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]6.105[/TD]
[TD="align: center"]779.093[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.400[/TD]
[TD="align: center"]3.000[/TD]
[TD="align: center"]1.213[/TD]
[TD="align: center"]1.333[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]6.946[/TD]
[TD="align: center"]684.763[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]88[/TD]
[TD="align: center"]Taurus[/TD]
[TD="align: center"]3.000[/TD]
[TD="align: center"]1.123[/TD]
[TD="align: center"]1.451[/TD]
[TD="align: center"]1.777[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]7.351[/TD]
[TD="align: center"]647.036[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: center"]Taurus[/TD]
[TD="align: center"]1.320[/TD]
[TD="align: center"]1.783[/TD]
[TD="align: center"]3.000[/TD]
[TD="align: center"]1.365[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]7.468[/TD]
[TD="align: center"]636.899[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.500[/TD]
[TD="align: center"]1.999[/TD]
[TD="align: center"]3.000[/TD]
[TD="align: center"]1.320[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]7.819[/TD]
[TD="align: center"]608.308[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]48[/TD]
[TD="align: center"]Monte[/TD]
[TD="align: center"]1.100[/TD]
[TD="align: center"]3.000[/TD]
[TD="align: center"]3.000[/TD]
[TD="align: center"]1.345[/TD]
[TD="align: center"]=[/TD]
[TD="align: center"]8.445[/TD]
[TD="align: center"]563.217[/TD]
[TD="align: center"]11[/TD]
[/TR]
</tbody>[/TABLE]


Thoughts?

 

[Yoti14]

yeah I know it looks already sorted, it was, manually. I posted the wrong look. Still would like this to be done automatically

 

[Aladin Akyurek]

Sorting by means of formulas cannot occur in-place, that is, it must happen somewhere else.

 

[Yoti14]

Ok, if not a formula, then what about a macro that targets the specific cells?

 

[Aladin Akyurek]

Ok, if not a formula, then what about a macro that targets the specific cells?

You could record a macro while you do the in-place sorting manually.

 

[Yoti14]

You could record a macro while you do the in-place sorting manually.

Ok, how would I do that? lol I know nothing about Macros and what they can do. Admittedly I just read a little about the subject.

 

[Aladin Akyurek]

Ok, how would I do that? lol I know nothing about Macros and what they can do. Admittedly I just read a little about the subject.

Activate the question mark (the ? icon) on the ribbon and search for "macro recorder" in the search dialog. That provides enough information.

 

[Peter_SSs]

1. What should trigger a re-sort?

2. Is this a formal Excel Table (created perhaps via Insert -> Table)? If so, what is the name of the table?

3. Which columns are formulas and which are manually entered?

4. Is there anything in column AK or AV?
- If there is, should those columns be excluded from the sort?