I need a hand in sorting continuously xy coordinates on the same route

I am looking for a formula where I have 2 data columns of X and Y coordinates (OFFICIALLY nominated Easing& Northing ) extracted randomly from AutoCAD.
Hope from the experts to help me in generating a formula that allows me to sort the data X,Y in the same order (P1,P2,P3, ...... ) along the route of points even some x values along the route comes before others.

I tried this formula in a separate column to do the sorting issue, but i still has bugs that certain points along the route when sorted comes before while it has to be after.

SQRT(($E$2-A2)^2+($F$2-B2)^2)

The first lower start point on the route is : X= 81600.454 Y=80140.616 Elevation =69.27
The Last upper point on the route is : X=79017.327 Y=83348.54 Elevation =17.68

my coordinates will change so this needs to be taken into account.
The Cartesian origin (0,0) is the reference
Thanks for your help

I couldn't upload the workbook of random points.

Here are the points of random xy:
x- input y - input
79633.64 80129.324
79604.652 80122.229
79574.997 80116.594
79662.42 80137.859
79746.222 80169.809
79718.642 80158.058
79690.685 80147.556
79425.777 80112.007
79396.01 80115.642
79366.509 80120.625
79455.729 80109.835
79545.4 80112.461
79515.463 80110.17
79485.586 80109.33
79999.955 80328.807
79974.901 80312.327
79949.853 80295.897
80024.744 80345.116
80100.037 80394.651
80075.029 80378.002
80049.956 80361.644
79824.85 80213.474
79799.433 80197.478
79773.246 80182.827
79849.928 80229.934
79924.798 80279.517
79899.858 80263.134
79874.863 80246.261
78917.966 80447.19
78898.908 80470.303
78879.171 80492.875
78937.085 80424.105
78995.14 80355.378
78975.665 80378.225
78956.443 80401.18
78801.881 80584.578
78782.66 80607.416
78763.205 80630.338
78821.35 80561.638
78859.746 80515.778
78859.766 80515.744
78840.343 80538.497
79224.494 80167.114
79197.646 80180.106
79171.614 80195.13
79252.013 80155.01
79337.334 80127.176
79308.399 80134.861
79279.912 80144.346
79054.583 80287.955
79033.937 80309.737
79014.485 80332.512
79076.114 80267.229
79146.328 80211.136
79122.196 80228.859
79098.787 80247.46
80124.953 80411.039
81142.032 80424.23
81116.715 80439.965
81091.026 80455.595
81167.72 80408.572
81244.497 80361.881
81219.194 80377.673
81193.287 80392.699
80963.567 80534.32
80938.174 80550.099
80912.649 80565.617
80988.966 80518.298
81065.226 80471.084
81039.729 80486.575
81014.65 80502.727
81499.704 80205.482
81474.364 80221.312
81448.99 80237.201
81524.774 80189.37
81600.454 80140.616
81575.798 80157.649
81550.812 80174.244
81321.039 80314.829
81295.604 80330.49
81269.37 80345.746
81346.529 80299.376
81423.17 80252.516
81397.535 80267.989
81372.077 80283.58
80374.553 80576.699
80349.988 80559.386
80325 80542.736
80400.192 80592.072
80482.19 80627.804
80453.998 80617.876
80426.532 80606.128
80200.023 80460.4
80174.88 80444.176
80150.157 80427.434
80225.104 80476.956
80300.075 80526.24
80275.236 80509.58
80250.309 80493.174
80777.502 80629.328
80748.476 80636.796
80719.15 80642.812
80805.621 80619.449
80886.847 80580.734
80860.584 80595.514
80833.499 80608.272
80570.111 80646.017
80540.562 80640.812
80511.284 80635.575
80599.914 80649.589
80689.527 80646.909
80659.726 80649.484
80629.772 80650.305
78743.712 80653.046
77986.181 81679.621
77991.746 81650.285
77999.01 81621.284
77981.913 81709.222
77977.847 81798.966
77977.609 81768.917
77979.138 81739.065
78056.094 81483.545
78071.435 81457.816
78088.144 81433.078
78042.003 81509.95
78007.658 81592.702
78017.678 81564.517
78029.185 81536.893
78059.973 82083.584
78045.498 82057.383
78032.703 82030.465
78075.929 82108.817
78128.753 82181.395
78110.5 82157.67
78092.643 82133.615
77987.651 81888.238
77983.153 81858.651
77979.842 81828.887
77993.641 81917.621
78020.965 82003.023
78010.463 81975.126
78001.441 81946.532
78453.725 80997.066
78473.086 80974.19
78492.327 80951.383
78434.405 81019.941
78376.361 81088.507
78395.695 81065.663
78415.09 81042.776
78589.092 80836.562
78608.303 80813.497
78627.775 80790.618
78569.666 80859.396
78511.711 80928.469
78531.037 80905.504
78550.384 80882.481
78182.849 81317.53
78201.988 81294.516
78221.452 81271.767
78163.414 81340.246
78106.019 81409.087
78125.076 81386.094
78144.222 81363.126
78318.155 81157.118
78337.631 81134.25
78356.955 81111.332
78298.774 81180.055
78240.791 81248.879
78260.069 81225.873
78279.404 81202.944
78146.945 82205.156
78836.572 83110.477
78818.482 83086.629
78800.544 83062.675
78854.778 83134.182
78909.024 83205.483
78890.817 83181.908
78872.982 83157.818
78709.693 82943.674
78691.473 82919.896
78673.326 82895.95
78727.87 82967.392
78782.387 83038.826
78764.116 83015.053
78746.239 82991.118
78646.914 80767.524
79071.511 83420.361
79053.45 83396.416
78666.018 80744.394
78705.131 80699.001
78724.48 80676.179
78685.588 80721.746
78963.139 83276.969
78945.12 83253.099
78927.229 83229.134
78981.225 83300.772
79035.222 83372.548
79017.327 83348.54
78999.307 83324.647
78328.985 82442.44
78310.842 82418.558
78292.778 82394.818
78347.045 82466.389
78401.177 82538.164
78383.078 82514.229
78365.131 82490.32
78201.259 82276.566
78183.231 82252.677
78165.133 82228.891
78219.472 82300.21
78274.234 82371.287
78255.795 82347.781
78237.648 82323.976
78582.518 82776.667
78564.384 82752.865
78546.352 82728.985
78600.729 82800.573
78655.144 82872.082
78637.049 82848.209
78618.94 82824.359
78455.632 82609.853
78437.334 82585.909
78419.28 82561.936
78473.728 82633.702
78528.081 82705.134
78509.996 82681.259
78491.854 82657.459

Thanks for response.

But actually the code computes distances between coordinates without sorting or ranking.