Auto Sorting a group of cells highest to lowest

Yoti14

New Member
Joined
Sep 6, 2017
Messages
8
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?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
yeah I know it looks already sorted, it was, manually. I posted the wrong look. Still would like this to be done automatically
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top