Spreadsheet: 175952d1345675314-help-with-rank-auto-sort-features-spreadsheet-attached-sortexample1
Sheet: Allow Ties

Rank | Name | Points | Standing
18 | [NAME] | 421 | 18th Place | 18.0002
22 | [NAME] | 48 | 22nd Place | 22.0003
1 | Amanda | 115252 | 1st Place | 1.0004
25 | Otis | 3 | 25th Place | 25.0005
20 | [NAME] | 95 | 20th Place | 20.0006 | Current Result |  |  |  |  |  |  |  | Desired Result
15 | [NAME] | 652 | 15th Place | 15.0007
14 | [NAME] | 662 | 14th Place | 14.0008
24 | Cameron | 4 | 24th Place | 24.0009 | Standings (Concatenate Formula) |  |  |  |  |  | like this |  | Standings (Concatenate Formula)
21 | [NAME] | 93 | 21st Place | 21.001 | 1st Place - Amanda |  |  |  |  |  | 1st Place-Amanda |  | 1st Place - Amanda
5 | [NAME] | 9122 | 5th Place | 5.0011 | 2nd Place - Taylor |  |  |  |  |  | 2nd Place-Taylor |  | 2nd Place - Taylor
10 | [NAME] | 1506 | 10th Place | 10.0012 | 3rd Place - Trish |  |  |  |  |  | 3rd Place-Trish |  | 3rd Place - Trish
10 | Geo | 1506 | 10th Place | 10.0013 | 4th Place - Stephanie |  |  |  |  |  | 4th Place-Stephanie |  | 4th Place - Stephanie
7 | Jamal | 8452 | 7th Place | 7.0014 | 5th Place - Darren |  |  |  |  |  | 5th Place-Darren |  | 5th Place - Darren
12 | [NAME] | 951 | 12th Place | 12.0015 | 6th Place - Stephen |  |  |  |  |  | 6th Place-Stephen |  | 6th Place - Stephen
19 | Jolleane | 357 | 19th Place | 19.0016 | 7th Place - Jamal |  |  |  |  |  | 7th Place-Jamal |  | 7th Place - Jamal
17 | JT | 482 | 17th Place | 17.0017 | 8th Place - Larry |  |  |  |  |  | 8th Place-Larry |  | 8th Place - Larry
9 | Kelly | 2112 | 9th Place | 9.0018 | 9th Place - Kelly |  |  |  |  |  | 9th Place-Kelly |  | 9th Place - Kelly
8 | [NAME] | 6759 | 8th Place | 8.0019 | 10th Place - Eric |  |  |  |  |  | 10th Place-Eric |  | 10th Place - Eric
16 | Orly | 532 | 16th Place | 16.002 | #N/A |  |  |  |  |  | 10th Place-Geo |  | 10th Place - Geo
22 | Rich | 48 | 22nd Place | 22.0021 | 12th Place - Joanie |  |  |  |  |  | 12th Place-Joanie |  | 12th Place - Joanie
4 | [NAME] | 9624 | 4th Place | 4.0022 | 13th Place - Will |  |  |  |  |  | 13th Place-Will |  | 13th Place - Will
6 | Stephen | 8863 | 6th Place | 6.0023 | 14th Place - Brian |  |  |  |  |  | 14th Place-Brian |  | 14th Place - Brian
2 | [NAME] | 12486 | 2nd Place | 2.0024 | 15th Place - Brad |  |  |  |  |  | 15th Place-Brad |  | 15th Place - Brad
3 | Trish | 9647 | 3rd Place | 3.0025 | 16th Place - Orly |  |  |  |  |  | 16th Place-Orly |  | 16th Place - Orly
13 | Will | 852 | 13th Place | 13.0026 | 17th Place - JT |  |  |  |  |  | 17th Place-JT |  | 17th Place - JT
 |  |  |  |  | 18th Place - Alex |  |  |  |  |  | 18th Place-Alex |  | 18th Place - Alex
 |  |  |  |  | 19th Place - Jolleane |  |  |  |  |  | 19th Place-Jolleane |  | 19th Place - Jolleane
Rankings | Standing | Name |  |  | 20th Place - Andy |  |  |  |  |  | 20th Place-Andy |  | 20th Place - Andy
1 | 1st Place | Amanda |  |  | 21st Place - Dan |  |  |  |  |  | 21st Place-Dan |  | 21st Place - Dan
2 | 2nd Place | [NAME] |  |  | 22nd Place - Allison |  |  |  |  |  | 22nd Place-Allison |  | 22nd Place - Allison
3 | 3rd Place | Trish |  |  | #N/A |  |  |  |  |  | 22nd Place-Rich |  | 22nd Place - Rich
4 | 4th Place | [NAME] |  |  | 24th Place - Cameron |  |  |  |  |  | 24th Place-Cameron |  | 24th Place - Cameron
5 | 5th Place | [NAME] |  |  | 25th Place - Otis |  |  |  |  |  | 25th Place-Otis |  | 25th Place - Otis
6 | 6th Place | Stephen
7 | 7th Place | Jamal
8 | 8th Place | [NAME]
9 | 9th Place | Kelly
10 | 10th Place | [NAME]
11 | #N/A | #N/A
12 | 12th Place | [NAME]
13 | 13th Place | Will
14 | 14th Place | [NAME]
15 | 15th Place | [NAME]
16 | 16th Place | Orly
17 | 17th Place | JT
18 | 18th Place | [NAME]
19 | 19th Place | Jolleane
20 | 20th Place | [NAME]
21 | 21st Place | [NAME]
22 | 22nd Place | [NAME]
23 | #N/A | #N/A
24 | 24th Place | Cameron
25 | 25th Place | Otis