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

Car#	Car Make	Lane 1	Lane 2	Lane 3	Lane4	=	Totals	Scale Speed	Qual Pos.
40	Intrepid	1.210	1.213	1.345	1.100	=	4.868	977.067	10
15	Monte	1.230	1.342	1.354	1.213	=	5.139	925.543	3
8	Monte	1.100	1.320	1.500	1.650	=	5.570	853.925	2
31	Monte	1.100	1.789	1.245	1.561	=	5.695	835.182	8
24	Monte	1.900	1.388	1.239	1.230	=	5.757	826.188	6
29	Monte	1.880	1.213	1.324	1.365	=	5.782	822.616	7
1	Monte	1.210	1.670	1.444	1.781	=	6.105	779.093	1
18	Monte	1.400	3.000	1.213	1.333	=	6.946	684.763	4
88	Taurus	3.000	1.123	1.451	1.777	=	7.351	647.036	12
38	Taurus	1.320	1.783	3.000	1.365	=	7.468	636.899	9
20	Monte	1.500	1.999	3.000	1.320	=	7.819	608.308	5
48	Monte	1.100	3.000	3.000	1.345	=	8.445	563.217	11

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

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?