Data in cell wrong way round ie "15.22=1|13.33=3" should be "1=15.22|3=13.33" - must finish with data in 1 cell

dshtesy

New Member
Joined
Jun 22, 2023
Messages
8
Office Version
  1. 365
Platform
  1. Windows
A colleague has passed me the below data and asked if the numbers either side of each "=" can be swapped.

I wondered about doing a text split to break down each cell and then just building it back together again, but came a bit unstuck when I realised that some cells have more than one of the "|" which I believe is acting as text separator for another piece of software where the data will be sent.

To help with clarity, cell A2 should be "1=15.38|3=13.85" and cell A15 (the first cell with 3 sets of data instead of 2) should be "1=4.25|40=1.76|120=1.65"

Please can someone advise on the best way to correct the data.

Thank you in advance!


Wholesale.csv
A
1FINAL DATA
215.38=1|13.85=3
321.05=1|18.94=3
423.56=1|21.21=3
531.84=1|28.66=3
648.35=1|43.51=3
753.32=1|48=3
881.61=1|73.44=3
996.72=1|87.05=3
1012.14=1|10.92=10
1113.34=1|12=10
124.64=1|4.18=10
131.45=1|1.2=5
143.08=1|2.36=70
154.25=1|1.76=40|1.65=120
166.31=1|5.49=10
176.36=1|5.52=12|5.26=36
1815.95=1|13.87=12|13.27=36
193.08=1|2.36=60
2015.26=1|11.51=12
211.9=1|1.7=100
223.08=1|2.36=60|2.16=120
236.36=1|5.52=12|5.26=36
240.93=1|0.84=100
2537.25=1|33.53=5
261.2=1|1.08=100
271.47=1|1.3=100
281.45=1|1.29=100
292.33=1|2.09=120
301.28=1|1.17=100
312.27=1|2.03=50
3222.4=1|20.15=5
3322.93=1|21.62=5
341.62=1|1.45=100
353.26=1|2.93=50
362.64=1|2.37=50
371.62=1|1.45=50
381.7=1|1.53=100
395.17=1|4.64=12
405.17=1|4.64=12
415.17=1|4.64=12
425.17=1|4.64=12
435.17=1|4.64=12
447.15=1|6.45=12
455.17=1|4.64=12
465.17=1|4.64=12
475.17=1|4.64=12
485.17=1|4.64=10
491.8=1|1.62=60
502.52=1|2.3=25
517.36=1|6.63=10
522.06=1|1.85=50
531.56=1|1.41=10
5417.26=1|15.54=10|12.43=20
5517.26=1|15.54=10|12.43=20
5617.26=1|15.54=10|12.43=20
5718.99=1|17.1=10|13.67=20
589.25=1|8.31=10
5910.12=1|9.1=10
6011.18=1|10.07=10
6113.38=1|12.03=10
6222.8=1|20.52=10
6327.51=1|24.76=10
6411.54=1|10.38=56
6514.09=1|12.68=48
6620.04=1|16.18=48
6714.83=1|13.38=56
6817.52=1|14.78=56
696.72=1|6.05=12
706.72=1|6.05=12
718.25=1|7.41=4
728.25=1|7.41=4
738.25=1|7.41=4
748.25=1|7.41=4
758.25=1|7.41=4
767.19=1|6.46=4
777.19=1|6.46=4
7825.78=1|27.42=1
7927.42=1|27.42=1
8027.42=1|27.42=1
8127.42=1|17.66=1
8217.66=1|15.89=56
8321.73=1|19.55=56
847.87=1|7.51=60
8539.55=1|35.86=3
8613.57=1
8719.46=1|17.51=4
886.18=1|5.49=10
894.27=1|3.85=25
904.27=1|3.85=25
914.27=1|3.85=25
923.26=1|2.93=25
934.74=1
947.66=1|6.97=6
9516.61=1|14.93=3
965.13=1
9716.37=1|14.76=4
9816.37=1|14.76=4
9916.37=1|14.76=4
10016.37=1|14.76=4
10117.88=1|16.08=50
10222.24=1|20.02=56
10312.23=1|11.02=12
1042.05=1|1.85=100
1052.05=1|1.85=100
1061.66=1|1.5=100
1071.66=1|1.5=100
1081.66=1|1.5=100
1091.66=1|1.5=100
1101.66=1|1.5=100
1111.66=1|1.5=100
1121.66=1|1.5=100
1131.66=1|1.5=100
11416.49=1|14.91=10
11516.49=1|14.91=10
11616.49=1|14.91=10
11716.49=1|14.91=10
11816.49=1|14.91=10
11916.49=1|14.91=10
12016.49=1|14.91=10
12116.49=1|14.91=10
1228.99=1|8.08=10
1234.64=1|4.18=50
1245.73=1|5.13=50
1258.13=1|7.31=20
1267.13=1|6.42=20
12710.07=1|9.05=20
1289.02=1|8.13=20
1292.43=1|1.78=1
1301.78=1
1318.74=1|7.88=20
1329.56=1|8.62=20
1339.56=1|8.62=20
1346.4=1|5.77=5
1356.67=1|6.01=5
1366.67=1|6.01=5
1376.33=1|5.7=20
1387.86=1|7.07=20
1396.33=1|5.7=20
1406.67=1|6.01=20
1417.86=1|7.07=20
1424.9=1|4.41=20
1434.9=1|4.41=20
14431.5=35|25.99=65|22.5=130|20.99=325
14540.41=1|31.99=50|29.99=100|28.5=250
14636.5=1|32.86=10
1470.79=1|0.62=220
14837.65=10|33.9=60
1498.62=1|7.76=10|5.59=150|5.33=300
1508.62=1|7.76=10|5.95=150|5.67=300
1519.09=1|8.2=10|6.56=150|6.25=300
1528.62=1|7.76=10|6.14=150|5.85=300
1537.56=1|6.71=10|6.15=50
15470.03=1
155141.61=1
156151.23=1
15797.01=1
158118.21=1
159125.73=1
160140.73=1
161155.72=1
162178.22=1
163200.71=1
1640.89=1|0.77=1000
16510.5=79|10.1=158|9.8=395
16610.7=75|10.4=150|9.99=375
16722.36=50|21.23=100|20.78=250
16826.53=40|25.21=80|24.66=200
16936.99=35|35.99=70|34.99=175
1709=1|8.39=10
17123.51=1|19.59=6
17254.35=1|46.88=8
1737.49=75|6.5=150|6.19=300|5.98=750
17438.58=1|34.72=32
1757.9=12|7.02=24|6.33=60|5.96=120
17633.57=1|30.41=5
1776.03=1|5.42=12
1786.03=1|5.42=12
17922.87=1|20.58=32
1802.58=1|2.35=18
1815.57=1|5.29=12
1826.63=8|5.98=16|5.48=32|4.98=48
1832.97=1|2.67=18
1847.39=8|6.72=16|6.16=32|5.6=48
18514.6=1|13.13=70
1862.6=1|2.33=10
1876.02=1|5.42=10
188103.29=1|90.52=3
18957.48=1|51.73=3
19058.04=1
191119.09=1|107.16=3
19258.04=1
19358.04=1
19413.09=1|11.79=2
195245.72=1|219.4=3
196258.77=1|231.07=3
197306.62=1|273.76=3
198258.77=1|231.07=3
199271.82=1|242.7=3
200319.66=1|285.42=3
20122.44=1|20.19=10
20227.44=1|24.71=10
203128.8=1|119.14=3
20419.96=1|18.46=10
20516.74=1|15.48=10
2067.94=1
2077.94=1
20858.05=1|51.73=3
20958.05=1|51.73=3
21091.26=1|79.85=3
211106.26=1|95.64=3
212148.36=1|127.18=5
213156.3=1|133.98=5
214178.95=1|153.38=5
215172.15=1|147.56=5
216174.74=1|152.9=5
2176.88=1|6.2=30
218122.61=1|110.24=3
2196.18=1|5.55=10
2206.18=1|5.55=10
22110.51=1|9.45=10
2229.23=1|8.3=10
22311.49=1|10.35=10
22416.84=1|15.18=10
22523.31=1|20.97=10
22627.14=1|24.44=10
22735.48=1|31.93=10
22842.47=1|38.21=10
22962.38=1|56.15=10
23038.18=1|36.27=5|34.36=10
23139.87=1|37.88=5|35.72=10
23210.53=1|9.49=10
23311.46=1|10.31=10|8.25=20
23413.66=1|12.3=10|9.84=20
23517.16=1|15.44=10
23623.65=1|21.29=10
23726.65=1|23.99=10
23834.88=1|31.41=10
23962.92=1|56.62=10
24094.49=1|85.04=10
241116.61=1|104.97=10
24251.93=1|46.74=10
24360.57=1|54.51=10
24469.24=1|62.32=10
2453.45=1|3.09=10
2463.45=1|3.09=10
2473.45=1|3.09=10
2483.45=1|3.09=10
2493.45=1|3.09=10
2503.45=1|3.09=10
2516.1=150|5.78=300|5.35=750
2529.03=1|8.14=100|7.49=500
25366.6=1
25424.76=1
25537.12=1
25661.89=1
25774.27=1
25894.31=1
259148.53=1
260198.05=1
261247.56=1
262297.1=1
2634.23=1|3.8=50 |3.33=100|2.92=150
2644.23=1|3.8=50 |3.33=100|2.92=150
2654.23=1|3.8=50 |3.33=100|2.92=150
2664.23=1|3.8=50 |3.33=100|2.92=150
2674.23=1|3.8=50 |3.33=100|2.92=150
2684.23=1|3.8=50 |3.33=100|2.92=150
2694.23=1|3.8=50 |3.33=100|2.92=150
2704.84=1|4.15=25|3.45=100
2714.84=1|4.15=25|3.45=100
2724.23=1|3.8=50 |3.33=100|2.92=150
2734.23=1|3.8=50 |3.33=100|2.92=150
2744.23=1|3.8=50 |3.33=100|2.92=150
2754.84=1|4.15=25|3.45=100
2764.23=1|3.79=25|3.16=100
2776.04=1|5.43=25
2784.23=1|3.79=25|3.16=100
2794.84=1|4.15=25|3.45=100
2804.84=1|4.15=25|3.45=100
2814.84=1|4.15=25|3.45=100
2824.84=1|4.15=25|3.45=100
2834.84=1|4.15=25|3.45=100
2844.84=1|4.15=25|3.45=100
2854.84=1|4.15=25|3.45=100
2864.84=1|4.15=25|3.45=100
2874.84=1|4.15=25|3.45=100
2884.84=1|4.15=25|3.45=100
2894.84=1|4.15=25|3.45=100
2904.84=1|4.15=25|3.45=100
2915.83=1|5.26=5
2925.83=1|5.26=5
2935.83=1|5.26=5
2945.83=1|5.26=5
2955.83=1|5.26=5
2965.83=1|5.26=5
2975.83=1|5.26=5
2985.83=1|5.26=5
2995.83=1|5.26=5
3005.83=1|5.26=5
3015.83=1|5.26=5
3025.83=1|5.26=5
3035.83=1|5.26=5
3045.83=1|5.26=5
3055.83=1|5.26=5
3065.83=1|5.26=5
3075.83=1|5.26=5
3085.83=1|5.26=5
3095.83=1|5.26=5
3105.83=1|5.26=5
3115.83=1|5.26=5
3120.91=1|0.82=100
3130.98=1|0.86=100
3141.08=1|0.96=100
3150.92=1|0.83=100
3161.05=1|0.93=100
3171.11=1|1=100
3186.04=1|4.87=50|4.39=100
3196.04=1|4.87=50|4.39=100
3206.64=1|5.97=20|5.36=50
3216.64=1|5.97=20|5.36=50
3225.83=1|5.26=5
3235.83=1|5.26=5
3246.64=1|5.97=20|5.36=50
3256.64=1|5.97=20|5.36=50
3265.83=1|5.26=5
3275.83=1|5.26=5
3286.64=1|5.97=20|5.36=50
3296.64=1|5.97=20|5.36=50
3305.83=1|5.26=5
3315.83=1|5.26=5
3326.64=1|5.97=20|5.36=50
3336.64=1|5.97=20|5.36=50
3345.83=1|5.26=5
3355.83=1|5.26=5
3365.31=1|4.77=5
3375.31=1|4.77=5
3386.64=1|5.97=20|5.36=50
3396.64=1|5.97=20|5.36=50
3405.83=1|5.26=5
3415.83=1|5.26=5
3426.04=1|4.87=50|4.39=100
3436.04=1|4.87=50|4.39=100
3445.31=1|4.77=5
3455.31=1|4.77=5
3464.23=1|3.8=50|3.33=100|2.92=150
3474.23=1|3.8=50|3.33=100|2.92=150
3484.23=1|3.8=50|3.33=100|2.92=150
3493.09=1|2.78=5
3503.09=1|2.78=5
3513.09=1|2.78=5
3525.6=1|5.03=20
3535.6=1|5.03=20
35415.53=1|13.99=10
3550.78=1|0.71=100
3560.98=1|0.86=100
3571.11=1|1=100
3581.11=1|1=100
3590.98=1|0.86=100
3601.16=1|1.03=100
3611.28=1|1.17=100
3620.98=1|0.86=100
3631.16=1|1.03=100
36421.58=1|19.41=20
36521.58=1|19.41=20
36621.58=1|19.41=20
36721.58=1|19.41=20
36821.58=1|19.41=20
36921.58=1|19.41=20
3707.75=1|6.97=5
3717.35=1|6.62=5
3727.35=1|6.62=5
373186.19=1
374214.32=1
375234.9=1
376254.36=1
377273.85=1
378314.98=1
379353.97=1
38016.23=1
38146.54=1
382110.4=1
383120.15=1
384180.76=1
38520.19=1|18.17=6
386316.73=1|291.39=3
38761.17=1
38885.08=1
389107.76=1
390135.04=1
391153.34=1
392173.27=1
393189.87=1
394238.72=1
395258.51=1
396286.94=1
397323.09=1
398340.26=1
399410.52=1
400495.21=1
401526.01=1
40236.19=1
403149.48=1
404122.61=1|110.24=6
40551.15=1
406211.22=1
407422.43=1
40841.1=1|37.81=5
40924.83=1|22.2=5
4105.17=1|4.64=12
41166.38=1
412117.9=1|98.25=3
413183.39=1|157.19=3
414117.9=1|98.26=3
415183.39=1|157.19=9
416654.34=1
417294.08=1
4187.3=12|6.53=24|5.59=60
41921.14=1|19.01=6|16.93=48
42010.09=1|8.77=6|7.74=12
42114.85=1|12.92=6|12.39=12
4227.84=1|7.2=10
4235.24=20|5.03=200|4.84=1000
4249.68=100|8.75=320|7.84=960
4251.95=500|1.64=2000|1.42=6000
4269.15=24|7.84=96|7.32=240
42758.96=2|51.09=10|47.03=164
42878.58=1|73.34=5|72.04=10
4291.64=1|1.25=1000|1.17=3000|1.05=6000
430286.44=1|276.42=5
4319.15=24|7.84=48|6.53=96
43278.58=1|73.34=5|72.04=10
43315.39=1|14.61=10
43478.58=1|73.34=5|72.04=10
43578.58=1|73.34=5|72.04=10
436238.03=1|226.13=5
437168.98=1|152.09=5
438144.08=1|137.52=5
439370.61=1|357.65=5
44015.71=10
44115.71=10
442155.89=1|142.78=5
44310.8=1|9.1=12|8.06=24
4446.22=12|5.24=24
44513.43=50|13.09=100|12.45=250
44613.43=50|13.09=100|12.45=250
44713.43=50|13.09=100|12.45=250
448332.75=1|313.09=3
449332.75=1|313.09=3
4505.85=1
4514.84=1|4.15=25|3.45=100
4524.84=1|4.15=25|3.45=100
4534.84=1|4.15=25|3.45=100
4544.84=1|4.15=25|3.45=100
4554.84=1|4.15=25|3.45=100
4564.84=1|4.15=25|3.45=100
4574.84=1|4.15=25|3.45=100
4584.84=1|4.15=25|3.45=100
4594.84=1|4.15=25|3.45=100
4604.84=1|4.15=25|3.45=100
4614.84=1|4.15=25|3.45=100
4624.84=1|4.15=25|3.45=100
46320.15=1|17.47=50
46424.01=1|20.15=40
465220.29=0
46623.02=0
46741.74=0
46827.35=0
46921.59=0
4708.68=1|7.6=12|6.71=24
4717.73=1|7.27=12|6.71=24
472485.97=1
473902.21=1
474232.47=1
47515=1|12.41=12|11.75=24
4769.99=75
47712.87=1|12.31=12
4783.24=1|0.75=1000|0.6=10000
47935.79=85|32.79=170|31=255
480152.73=1
481173.23=1
482408.98=1
483562.73=1
484179.38=1
4851331.48=1
4862.2=1000|2=2000
48725=1
48845=1
48910.83=1|9.84=5|8.4=10
490460.23=1|408.98=3|378.23=6
49111=1|10.38=7|10.16=35|9.64=70
49219.45=1|18.43=7|17.4=35|16.38=70
49329.61=35
49413.66=1|12.3=10|9.84=20
49517.16=1|15.44=10
49626.65=1|23.99=10
49717.26=1|15.54=10|12.43=20
49817.26=1|15.54=10|12.43=20
49917.26=1|15.54=10|12.43=20
50018.7=1|17.51=10|16.91=20
50127.51=1|24.76=10
50211.79=1|9.74=10|8.68=20
5037.01=1|5.59=40
5046.36=1|5.52=12|5.26=36
5056.36=1|5.52=12|5.26=36
50615.95=1|13.87=12|13.27=36
50717.02=1|8.62=40|7.98=120
50848.91=1|45.74=8|41.17=20|37.05=40
Wholesale
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
How about
Fluff.xlsm
AB
1FINAL DATA
215.38=1|13.85=31=15.38|3=13.85
321.05=1|18.94=31=21.05|3=18.94
423.56=1|21.21=31=23.56|3=21.21
531.84=1|28.66=31=31.84|3=28.66
648.35=1|43.51=31=48.35|3=43.51
753.32=1|48=31=53.32|3=48
881.61=1|73.44=31=81.61|3=73.44
996.72=1|87.05=31=96.72|3=87.05
1012.14=1|10.92=101=12.14|10=10.92
1113.34=1|12=101=13.34|10=12
124.64=1|4.18=101=4.64|10=4.18
131.45=1|1.2=51=1.45|5=1.2
143.08=1|2.36=701=3.08|70=2.36
154.25=1|1.76=40|1.65=1201=4.25|40=1.76|120=1.65
166.31=1|5.49=101=6.31|10=5.49
176.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
1815.95=1|13.87=12|13.27=361=15.95|12=13.87|36=13.27
193.08=1|2.36=601=3.08|60=2.36
2015.26=1|11.51=121=15.26|12=11.51
211.9=1|1.7=1001=1.9|100=1.7
223.08=1|2.36=60|2.16=1201=3.08|60=2.36|120=2.16
236.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
240.93=1|0.84=1001=0.93|100=0.84
2537.25=1|33.53=51=37.25|5=33.53
261.2=1|1.08=1001=1.2|100=1.08
271.47=1|1.3=1001=1.47|100=1.3
281.45=1|1.29=1001=1.45|100=1.29
292.33=1|2.09=1201=2.33|120=2.09
301.28=1|1.17=1001=1.28|100=1.17
312.27=1|2.03=501=2.27|50=2.03
3222.4=1|20.15=51=22.4|5=20.15
3322.93=1|21.62=51=22.93|5=21.62
341.62=1|1.45=1001=1.62|100=1.45
353.26=1|2.93=501=3.26|50=2.93
362.64=1|2.37=501=2.64|50=2.37
371.62=1|1.45=501=1.62|50=1.45
381.7=1|1.53=1001=1.7|100=1.53
395.17=1|4.64=121=5.17|12=4.64
405.17=1|4.64=121=5.17|12=4.64
415.17=1|4.64=121=5.17|12=4.64
425.17=1|4.64=121=5.17|12=4.64
435.17=1|4.64=121=5.17|12=4.64
447.15=1|6.45=121=7.15|12=6.45
455.17=1|4.64=121=5.17|12=4.64
465.17=1|4.64=121=5.17|12=4.64
475.17=1|4.64=121=5.17|12=4.64
485.17=1|4.64=101=5.17|10=4.64
491.8=1|1.62=601=1.8|60=1.62
502.52=1|2.3=251=2.52|25=2.3
517.36=1|6.63=101=7.36|10=6.63
522.06=1|1.85=501=2.06|50=1.85
531.56=1|1.41=101=1.56|10=1.41
5417.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
5517.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
5617.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
5718.99=1|17.1=10|13.67=201=18.99|10=17.1|20=13.67
589.25=1|8.31=101=9.25|10=8.31
5910.12=1|9.1=101=10.12|10=9.1
6011.18=1|10.07=101=11.18|10=10.07
6113.38=1|12.03=101=13.38|10=12.03
6222.8=1|20.52=101=22.8|10=20.52
6327.51=1|24.76=101=27.51|10=24.76
6411.54=1|10.38=561=11.54|56=10.38
6514.09=1|12.68=481=14.09|48=12.68
6620.04=1|16.18=481=20.04|48=16.18
6714.83=1|13.38=561=14.83|56=13.38
6817.52=1|14.78=561=17.52|56=14.78
696.72=1|6.05=121=6.72|12=6.05
706.72=1|6.05=121=6.72|12=6.05
718.25=1|7.41=41=8.25|4=7.41
728.25=1|7.41=41=8.25|4=7.41
738.25=1|7.41=41=8.25|4=7.41
748.25=1|7.41=41=8.25|4=7.41
758.25=1|7.41=41=8.25|4=7.41
767.19=1|6.46=41=7.19|4=6.46
777.19=1|6.46=41=7.19|4=6.46
7825.78=1|27.42=11=25.78|1=27.42
7927.42=1|27.42=11=27.42|1=27.42
8027.42=1|27.42=11=27.42|1=27.42
8127.42=1|17.66=11=27.42|1=17.66
8217.66=1|15.89=561=17.66|56=15.89
8321.73=1|19.55=561=21.73|56=19.55
847.87=1|7.51=601=7.87|60=7.51
8539.55=1|35.86=31=39.55|3=35.86
8613.57=11=13.57
8719.46=1|17.51=41=19.46|4=17.51
886.18=1|5.49=101=6.18|10=5.49
894.27=1|3.85=251=4.27|25=3.85
904.27=1|3.85=251=4.27|25=3.85
914.27=1|3.85=251=4.27|25=3.85
923.26=1|2.93=251=3.26|25=2.93
934.74=11=4.74
947.66=1|6.97=61=7.66|6=6.97
9516.61=1|14.93=31=16.61|3=14.93
965.13=11=5.13
9716.37=1|14.76=41=16.37|4=14.76
9816.37=1|14.76=41=16.37|4=14.76
9916.37=1|14.76=41=16.37|4=14.76
10016.37=1|14.76=41=16.37|4=14.76
10117.88=1|16.08=501=17.88|50=16.08
10222.24=1|20.02=561=22.24|56=20.02
10312.23=1|11.02=121=12.23|12=11.02
1042.05=1|1.85=1001=2.05|100=1.85
1052.05=1|1.85=1001=2.05|100=1.85
1061.66=1|1.5=1001=1.66|100=1.5
1071.66=1|1.5=1001=1.66|100=1.5
1081.66=1|1.5=1001=1.66|100=1.5
1091.66=1|1.5=1001=1.66|100=1.5
1101.66=1|1.5=1001=1.66|100=1.5
1111.66=1|1.5=1001=1.66|100=1.5
1121.66=1|1.5=1001=1.66|100=1.5
1131.66=1|1.5=1001=1.66|100=1.5
11416.49=1|14.91=101=16.49|10=14.91
11516.49=1|14.91=101=16.49|10=14.91
11616.49=1|14.91=101=16.49|10=14.91
11716.49=1|14.91=101=16.49|10=14.91
11816.49=1|14.91=101=16.49|10=14.91
11916.49=1|14.91=101=16.49|10=14.91
12016.49=1|14.91=101=16.49|10=14.91
12116.49=1|14.91=101=16.49|10=14.91
1228.99=1|8.08=101=8.99|10=8.08
1234.64=1|4.18=501=4.64|50=4.18
1245.73=1|5.13=501=5.73|50=5.13
1258.13=1|7.31=201=8.13|20=7.31
1267.13=1|6.42=201=7.13|20=6.42
12710.07=1|9.05=201=10.07|20=9.05
1289.02=1|8.13=201=9.02|20=8.13
1292.43=1|1.78=11=2.43|1=1.78
1301.78=11=1.78
1318.74=1|7.88=201=8.74|20=7.88
1329.56=1|8.62=201=9.56|20=8.62
1339.56=1|8.62=201=9.56|20=8.62
1346.4=1|5.77=51=6.4|5=5.77
1356.67=1|6.01=51=6.67|5=6.01
1366.67=1|6.01=51=6.67|5=6.01
1376.33=1|5.7=201=6.33|20=5.7
1387.86=1|7.07=201=7.86|20=7.07
1396.33=1|5.7=201=6.33|20=5.7
1406.67=1|6.01=201=6.67|20=6.01
1417.86=1|7.07=201=7.86|20=7.07
1424.9=1|4.41=201=4.9|20=4.41
1434.9=1|4.41=201=4.9|20=4.41
14431.5=35|25.99=65|22.5=130|20.99=32535=31.5|65=25.99|130=22.5|325=20.99
14540.41=1|31.99=50|29.99=100|28.5=2501=40.41|50=31.99|100=29.99|250=28.5
14636.5=1|32.86=101=36.5|10=32.86
1470.79=1|0.62=2201=0.79|220=0.62
14837.65=10|33.9=6010=37.65|60=33.9
1498.62=1|7.76=10|5.59=150|5.33=3001=8.62|10=7.76|150=5.59|300=5.33
1508.62=1|7.76=10|5.95=150|5.67=3001=8.62|10=7.76|150=5.95|300=5.67
1519.09=1|8.2=10|6.56=150|6.25=3001=9.09|10=8.2|150=6.56|300=6.25
1528.62=1|7.76=10|6.14=150|5.85=3001=8.62|10=7.76|150=6.14|300=5.85
1537.56=1|6.71=10|6.15=501=7.56|10=6.71|50=6.15
15470.03=11=70.03
155141.61=11=141.61
156151.23=11=151.23
15797.01=11=97.01
158118.21=11=118.21
159125.73=11=125.73
160140.73=11=140.73
161155.72=11=155.72
162178.22=11=178.22
163200.71=11=200.71
1640.89=1|0.77=10001=0.89|1000=0.77
16510.5=79|10.1=158|9.8=39579=10.5|158=10.1|395=9.8
16610.7=75|10.4=150|9.99=37575=10.7|150=10.4|375=9.99
16722.36=50|21.23=100|20.78=25050=22.36|100=21.23|250=20.78
16826.53=40|25.21=80|24.66=20040=26.53|80=25.21|200=24.66
16936.99=35|35.99=70|34.99=17535=36.99|70=35.99|175=34.99
1709=1|8.39=101=9|10=8.39
17123.51=1|19.59=61=23.51|6=19.59
17254.35=1|46.88=81=54.35|8=46.88
1737.49=75|6.5=150|6.19=300|5.98=75075=7.49|150=6.5|300=6.19|750=5.98
17438.58=1|34.72=321=38.58|32=34.72
1757.9=12|7.02=24|6.33=60|5.96=12012=7.9|24=7.02|60=6.33|120=5.96
17633.57=1|30.41=51=33.57|5=30.41
1776.03=1|5.42=121=6.03|12=5.42
1786.03=1|5.42=121=6.03|12=5.42
17922.87=1|20.58=321=22.87|32=20.58
1802.58=1|2.35=181=2.58|18=2.35
1815.57=1|5.29=121=5.57|12=5.29
1826.63=8|5.98=16|5.48=32|4.98=488=6.63|16=5.98|32=5.48|48=4.98
1832.97=1|2.67=181=2.97|18=2.67
1847.39=8|6.72=16|6.16=32|5.6=488=7.39|16=6.72|32=6.16|48=5.6
18514.6=1|13.13=701=14.6|70=13.13
1862.6=1|2.33=101=2.6|10=2.33
1876.02=1|5.42=101=6.02|10=5.42
188103.29=1|90.52=31=103.29|3=90.52
18957.48=1|51.73=31=57.48|3=51.73
19058.04=11=58.04
191119.09=1|107.16=31=119.09|3=107.16
19258.04=11=58.04
19358.04=11=58.04
19413.09=1|11.79=21=13.09|2=11.79
195245.72=1|219.4=31=245.72|3=219.4
196258.77=1|231.07=31=258.77|3=231.07
197306.62=1|273.76=31=306.62|3=273.76
198258.77=1|231.07=31=258.77|3=231.07
199271.82=1|242.7=31=271.82|3=242.7
200319.66=1|285.42=31=319.66|3=285.42
20122.44=1|20.19=101=22.44|10=20.19
20227.44=1|24.71=101=27.44|10=24.71
203128.8=1|119.14=31=128.8|3=119.14
20419.96=1|18.46=101=19.96|10=18.46
20516.74=1|15.48=101=16.74|10=15.48
2067.94=11=7.94
2077.94=11=7.94
20858.05=1|51.73=31=58.05|3=51.73
20958.05=1|51.73=31=58.05|3=51.73
21091.26=1|79.85=31=91.26|3=79.85
211106.26=1|95.64=31=106.26|3=95.64
212148.36=1|127.18=51=148.36|5=127.18
213156.3=1|133.98=51=156.3|5=133.98
214178.95=1|153.38=51=178.95|5=153.38
215172.15=1|147.56=51=172.15|5=147.56
216174.74=1|152.9=51=174.74|5=152.9
2176.88=1|6.2=301=6.88|30=6.2
218122.61=1|110.24=31=122.61|3=110.24
2196.18=1|5.55=101=6.18|10=5.55
2206.18=1|5.55=101=6.18|10=5.55
22110.51=1|9.45=101=10.51|10=9.45
2229.23=1|8.3=101=9.23|10=8.3
22311.49=1|10.35=101=11.49|10=10.35
22416.84=1|15.18=101=16.84|10=15.18
22523.31=1|20.97=101=23.31|10=20.97
22627.14=1|24.44=101=27.14|10=24.44
22735.48=1|31.93=101=35.48|10=31.93
22842.47=1|38.21=101=42.47|10=38.21
22962.38=1|56.15=101=62.38|10=56.15
23038.18=1|36.27=5|34.36=101=38.18|5=36.27|10=34.36
23139.87=1|37.88=5|35.72=101=39.87|5=37.88|10=35.72
23210.53=1|9.49=101=10.53|10=9.49
23311.46=1|10.31=10|8.25=201=11.46|10=10.31|20=8.25
23413.66=1|12.3=10|9.84=201=13.66|10=12.3|20=9.84
23517.16=1|15.44=101=17.16|10=15.44
23623.65=1|21.29=101=23.65|10=21.29
23726.65=1|23.99=101=26.65|10=23.99
23834.88=1|31.41=101=34.88|10=31.41
23962.92=1|56.62=101=62.92|10=56.62
24094.49=1|85.04=101=94.49|10=85.04
241116.61=1|104.97=101=116.61|10=104.97
24251.93=1|46.74=101=51.93|10=46.74
24360.57=1|54.51=101=60.57|10=54.51
24469.24=1|62.32=101=69.24|10=62.32
2453.45=1|3.09=101=3.45|10=3.09
2463.45=1|3.09=101=3.45|10=3.09
2473.45=1|3.09=101=3.45|10=3.09
2483.45=1|3.09=101=3.45|10=3.09
2493.45=1|3.09=101=3.45|10=3.09
2503.45=1|3.09=101=3.45|10=3.09
2516.1=150|5.78=300|5.35=750150=6.1|300=5.78|750=5.35
2529.03=1|8.14=100|7.49=5001=9.03|100=8.14|500=7.49
25366.6=11=66.6
25424.76=11=24.76
25537.12=11=37.12
25661.89=11=61.89
25774.27=11=74.27
25894.31=11=94.31
259148.53=11=148.53
260198.05=11=198.05
261247.56=11=247.56
262297.1=11=297.1
2634.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2644.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2654.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2664.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2674.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2684.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2694.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2704.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2714.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2724.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2734.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2744.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2754.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2764.23=1|3.79=25|3.16=1001=4.23|25=3.79|100=3.16
2776.04=1|5.43=251=6.04|25=5.43
2784.23=1|3.79=25|3.16=1001=4.23|25=3.79|100=3.16
2794.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2804.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2814.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2824.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2834.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2844.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2854.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2864.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2874.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2884.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2894.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2904.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2915.83=1|5.26=51=5.83|5=5.26
2925.83=1|5.26=51=5.83|5=5.26
2935.83=1|5.26=51=5.83|5=5.26
2945.83=1|5.26=51=5.83|5=5.26
2955.83=1|5.26=51=5.83|5=5.26
2965.83=1|5.26=51=5.83|5=5.26
2975.83=1|5.26=51=5.83|5=5.26
2985.83=1|5.26=51=5.83|5=5.26
2995.83=1|5.26=51=5.83|5=5.26
3005.83=1|5.26=51=5.83|5=5.26
3015.83=1|5.26=51=5.83|5=5.26
3025.83=1|5.26=51=5.83|5=5.26
3035.83=1|5.26=51=5.83|5=5.26
3045.83=1|5.26=51=5.83|5=5.26
3055.83=1|5.26=51=5.83|5=5.26
3065.83=1|5.26=51=5.83|5=5.26
3075.83=1|5.26=51=5.83|5=5.26
3085.83=1|5.26=51=5.83|5=5.26
3095.83=1|5.26=51=5.83|5=5.26
3105.83=1|5.26=51=5.83|5=5.26
3115.83=1|5.26=51=5.83|5=5.26
3120.91=1|0.82=1001=0.91|100=0.82
3130.98=1|0.86=1001=0.98|100=0.86
3141.08=1|0.96=1001=1.08|100=0.96
3150.92=1|0.83=1001=0.92|100=0.83
3161.05=1|0.93=1001=1.05|100=0.93
3171.11=1|1=1001=1.11|100=1
3186.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3196.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3206.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3216.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3225.83=1|5.26=51=5.83|5=5.26
3235.83=1|5.26=51=5.83|5=5.26
3246.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3256.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3265.83=1|5.26=51=5.83|5=5.26
3275.83=1|5.26=51=5.83|5=5.26
3286.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3296.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3305.83=1|5.26=51=5.83|5=5.26
3315.83=1|5.26=51=5.83|5=5.26
3326.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3336.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3345.83=1|5.26=51=5.83|5=5.26
3355.83=1|5.26=51=5.83|5=5.26
3365.31=1|4.77=51=5.31|5=4.77
3375.31=1|4.77=51=5.31|5=4.77
3386.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3396.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3405.83=1|5.26=51=5.83|5=5.26
3415.83=1|5.26=51=5.83|5=5.26
3426.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3436.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3445.31=1|4.77=51=5.31|5=4.77
3455.31=1|4.77=51=5.31|5=4.77
3464.23=1|3.8=50|3.33=100|2.92=1501=4.23|50=3.8|100=3.33|150=2.92
3474.23=1|3.8=50|3.33=100|2.92=1501=4.23|50=3.8|100=3.33|150=2.92
3484.23=1|3.8=50|3.33=100|2.92=1501=4.23|50=3.8|100=3.33|150=2.92
3493.09=1|2.78=51=3.09|5=2.78
3503.09=1|2.78=51=3.09|5=2.78
3513.09=1|2.78=51=3.09|5=2.78
3525.6=1|5.03=201=5.6|20=5.03
3535.6=1|5.03=201=5.6|20=5.03
35415.53=1|13.99=101=15.53|10=13.99
3550.78=1|0.71=1001=0.78|100=0.71
3560.98=1|0.86=1001=0.98|100=0.86
3571.11=1|1=1001=1.11|100=1
3581.11=1|1=1001=1.11|100=1
3590.98=1|0.86=1001=0.98|100=0.86
3601.16=1|1.03=1001=1.16|100=1.03
3611.28=1|1.17=1001=1.28|100=1.17
3620.98=1|0.86=1001=0.98|100=0.86
3631.16=1|1.03=1001=1.16|100=1.03
36421.58=1|19.41=201=21.58|20=19.41
36521.58=1|19.41=201=21.58|20=19.41
36621.58=1|19.41=201=21.58|20=19.41
36721.58=1|19.41=201=21.58|20=19.41
36821.58=1|19.41=201=21.58|20=19.41
36921.58=1|19.41=201=21.58|20=19.41
3707.75=1|6.97=51=7.75|5=6.97
3717.35=1|6.62=51=7.35|5=6.62
3727.35=1|6.62=51=7.35|5=6.62
373186.19=11=186.19
374214.32=11=214.32
375234.9=11=234.9
376254.36=11=254.36
377273.85=11=273.85
378314.98=11=314.98
379353.97=11=353.97
38016.23=11=16.23
38146.54=11=46.54
382110.4=11=110.4
383120.15=11=120.15
384180.76=11=180.76
38520.19=1|18.17=61=20.19|6=18.17
386316.73=1|291.39=31=316.73|3=291.39
38761.17=11=61.17
38885.08=11=85.08
389107.76=11=107.76
390135.04=11=135.04
391153.34=11=153.34
392173.27=11=173.27
393189.87=11=189.87
394238.72=11=238.72
395258.51=11=258.51
396286.94=11=286.94
397323.09=11=323.09
398340.26=11=340.26
399410.52=11=410.52
400495.21=11=495.21
401526.01=11=526.01
40236.19=11=36.19
403149.48=11=149.48
404122.61=1|110.24=61=122.61|6=110.24
40551.15=11=51.15
406211.22=11=211.22
407422.43=11=422.43
40841.1=1|37.81=51=41.1|5=37.81
40924.83=1|22.2=51=24.83|5=22.2
4105.17=1|4.64=121=5.17|12=4.64
41166.38=11=66.38
412117.9=1|98.25=31=117.9|3=98.25
413183.39=1|157.19=31=183.39|3=157.19
414117.9=1|98.26=31=117.9|3=98.26
415183.39=1|157.19=91=183.39|9=157.19
416654.34=11=654.34
417294.08=11=294.08
4187.3=12|6.53=24|5.59=6012=7.3|24=6.53|60=5.59
41921.14=1|19.01=6|16.93=481=21.14|6=19.01|48=16.93
42010.09=1|8.77=6|7.74=121=10.09|6=8.77|12=7.74
42114.85=1|12.92=6|12.39=121=14.85|6=12.92|12=12.39
4227.84=1|7.2=101=7.84|10=7.2
4235.24=20|5.03=200|4.84=100020=5.24|200=5.03|1000=4.84
4249.68=100|8.75=320|7.84=960100=9.68|320=8.75|960=7.84
4251.95=500|1.64=2000|1.42=6000500=1.95|2000=1.64|6000=1.42
4269.15=24|7.84=96|7.32=24024=9.15|96=7.84|240=7.32
42758.96=2|51.09=10|47.03=1642=58.96|10=51.09|164=47.03
42878.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
4291.64=1|1.25=1000|1.17=3000|1.05=60001=1.64|1000=1.25|3000=1.17|6000=1.05
430286.44=1|276.42=51=286.44|5=276.42
4319.15=24|7.84=48|6.53=9624=9.15|48=7.84|96=6.53
43278.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
43315.39=1|14.61=101=15.39|10=14.61
43478.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
43578.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
436238.03=1|226.13=51=238.03|5=226.13
437168.98=1|152.09=51=168.98|5=152.09
438144.08=1|137.52=51=144.08|5=137.52
439370.61=1|357.65=51=370.61|5=357.65
44015.71=1010=15.71
44115.71=1010=15.71
442155.89=1|142.78=51=155.89|5=142.78
44310.8=1|9.1=12|8.06=241=10.8|12=9.1|24=8.06
4446.22=12|5.24=2412=6.22|24=5.24
44513.43=50|13.09=100|12.45=25050=13.43|100=13.09|250=12.45
44613.43=50|13.09=100|12.45=25050=13.43|100=13.09|250=12.45
44713.43=50|13.09=100|12.45=25050=13.43|100=13.09|250=12.45
448332.75=1|313.09=31=332.75|3=313.09
449332.75=1|313.09=31=332.75|3=313.09
4505.85=11=5.85
4514.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4524.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4534.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4544.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4554.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4564.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4574.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4584.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4594.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4604.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4614.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4624.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
46320.15=1|17.47=501=20.15|50=17.47
46424.01=1|20.15=401=24.01|40=20.15
465220.29=00=220.29
46623.02=00=23.02
46741.74=00=41.74
46827.35=00=27.35
46921.59=00=21.59
4708.68=1|7.6=12|6.71=241=8.68|12=7.6|24=6.71
4717.73=1|7.27=12|6.71=241=7.73|12=7.27|24=6.71
472485.97=11=485.97
473902.21=11=902.21
474232.47=11=232.47
47515=1|12.41=12|11.75=241=15|12=12.41|24=11.75
4769.99=7575=9.99
47712.87=1|12.31=121=12.87|12=12.31
4783.24=1|0.75=1000|0.6=100001=3.24|1000=0.75|10000=0.6
47935.79=85|32.79=170|31=25585=35.79|170=32.79|255=31
480152.73=11=152.73
481173.23=11=173.23
482408.98=11=408.98
483562.73=11=562.73
484179.38=11=179.38
4851331.48=11=1331.48
4862.2=1000|2=20001000=2.2|2000=2
48725=11=25
48845=11=45
48910.83=1|9.84=5|8.4=101=10.83|5=9.84|10=8.4
490460.23=1|408.98=3|378.23=61=460.23|3=408.98|6=378.23
49111=1|10.38=7|10.16=35|9.64=701=11|7=10.38|35=10.16|70=9.64
49219.45=1|18.43=7|17.4=35|16.38=701=19.45|7=18.43|35=17.4|70=16.38
49329.61=3535=29.61
49413.66=1|12.3=10|9.84=201=13.66|10=12.3|20=9.84
49517.16=1|15.44=101=17.16|10=15.44
49626.65=1|23.99=101=26.65|10=23.99
49717.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
49817.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
49917.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
50018.7=1|17.51=10|16.91=201=18.7|10=17.51|20=16.91
50127.51=1|24.76=101=27.51|10=24.76
50211.79=1|9.74=10|8.68=201=11.79|10=9.74|20=8.68
5037.01=1|5.59=401=7.01|40=5.59
5046.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
5056.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
50615.95=1|13.87=12|13.27=361=15.95|12=13.87|36=13.27
50717.02=1|8.62=40|7.98=1201=17.02|40=8.62|120=7.98
50848.91=1|45.74=8|41.17=20|37.05=401=48.91|8=45.74|20=41.17|40=37.05
Sheet4
Cell Formulas
RangeFormula
B2:B508B2=BYROW(A2:A508,LAMBDA(br,TEXTJOIN({"=","|"},,CHOOSECOLS(TEXTSPLIT(br,"=","|"),2,1))))
Dynamic array formulas.
 
Upvote 1
How about
Fluff.xlsm
AB
1FINAL DATA
215.38=1|13.85=31=15.38|3=13.85
321.05=1|18.94=31=21.05|3=18.94
423.56=1|21.21=31=23.56|3=21.21
531.84=1|28.66=31=31.84|3=28.66
648.35=1|43.51=31=48.35|3=43.51
753.32=1|48=31=53.32|3=48
881.61=1|73.44=31=81.61|3=73.44
996.72=1|87.05=31=96.72|3=87.05
1012.14=1|10.92=101=12.14|10=10.92
1113.34=1|12=101=13.34|10=12
124.64=1|4.18=101=4.64|10=4.18
131.45=1|1.2=51=1.45|5=1.2
143.08=1|2.36=701=3.08|70=2.36
154.25=1|1.76=40|1.65=1201=4.25|40=1.76|120=1.65
166.31=1|5.49=101=6.31|10=5.49
176.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
1815.95=1|13.87=12|13.27=361=15.95|12=13.87|36=13.27
193.08=1|2.36=601=3.08|60=2.36
2015.26=1|11.51=121=15.26|12=11.51
211.9=1|1.7=1001=1.9|100=1.7
223.08=1|2.36=60|2.16=1201=3.08|60=2.36|120=2.16
236.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
240.93=1|0.84=1001=0.93|100=0.84
2537.25=1|33.53=51=37.25|5=33.53
261.2=1|1.08=1001=1.2|100=1.08
271.47=1|1.3=1001=1.47|100=1.3
281.45=1|1.29=1001=1.45|100=1.29
292.33=1|2.09=1201=2.33|120=2.09
301.28=1|1.17=1001=1.28|100=1.17
312.27=1|2.03=501=2.27|50=2.03
3222.4=1|20.15=51=22.4|5=20.15
3322.93=1|21.62=51=22.93|5=21.62
341.62=1|1.45=1001=1.62|100=1.45
353.26=1|2.93=501=3.26|50=2.93
362.64=1|2.37=501=2.64|50=2.37
371.62=1|1.45=501=1.62|50=1.45
381.7=1|1.53=1001=1.7|100=1.53
395.17=1|4.64=121=5.17|12=4.64
405.17=1|4.64=121=5.17|12=4.64
415.17=1|4.64=121=5.17|12=4.64
425.17=1|4.64=121=5.17|12=4.64
435.17=1|4.64=121=5.17|12=4.64
447.15=1|6.45=121=7.15|12=6.45
455.17=1|4.64=121=5.17|12=4.64
465.17=1|4.64=121=5.17|12=4.64
475.17=1|4.64=121=5.17|12=4.64
485.17=1|4.64=101=5.17|10=4.64
491.8=1|1.62=601=1.8|60=1.62
502.52=1|2.3=251=2.52|25=2.3
517.36=1|6.63=101=7.36|10=6.63
522.06=1|1.85=501=2.06|50=1.85
531.56=1|1.41=101=1.56|10=1.41
5417.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
5517.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
5617.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
5718.99=1|17.1=10|13.67=201=18.99|10=17.1|20=13.67
589.25=1|8.31=101=9.25|10=8.31
5910.12=1|9.1=101=10.12|10=9.1
6011.18=1|10.07=101=11.18|10=10.07
6113.38=1|12.03=101=13.38|10=12.03
6222.8=1|20.52=101=22.8|10=20.52
6327.51=1|24.76=101=27.51|10=24.76
6411.54=1|10.38=561=11.54|56=10.38
6514.09=1|12.68=481=14.09|48=12.68
6620.04=1|16.18=481=20.04|48=16.18
6714.83=1|13.38=561=14.83|56=13.38
6817.52=1|14.78=561=17.52|56=14.78
696.72=1|6.05=121=6.72|12=6.05
706.72=1|6.05=121=6.72|12=6.05
718.25=1|7.41=41=8.25|4=7.41
728.25=1|7.41=41=8.25|4=7.41
738.25=1|7.41=41=8.25|4=7.41
748.25=1|7.41=41=8.25|4=7.41
758.25=1|7.41=41=8.25|4=7.41
767.19=1|6.46=41=7.19|4=6.46
777.19=1|6.46=41=7.19|4=6.46
7825.78=1|27.42=11=25.78|1=27.42
7927.42=1|27.42=11=27.42|1=27.42
8027.42=1|27.42=11=27.42|1=27.42
8127.42=1|17.66=11=27.42|1=17.66
8217.66=1|15.89=561=17.66|56=15.89
8321.73=1|19.55=561=21.73|56=19.55
847.87=1|7.51=601=7.87|60=7.51
8539.55=1|35.86=31=39.55|3=35.86
8613.57=11=13.57
8719.46=1|17.51=41=19.46|4=17.51
886.18=1|5.49=101=6.18|10=5.49
894.27=1|3.85=251=4.27|25=3.85
904.27=1|3.85=251=4.27|25=3.85
914.27=1|3.85=251=4.27|25=3.85
923.26=1|2.93=251=3.26|25=2.93
934.74=11=4.74
947.66=1|6.97=61=7.66|6=6.97
9516.61=1|14.93=31=16.61|3=14.93
965.13=11=5.13
9716.37=1|14.76=41=16.37|4=14.76
9816.37=1|14.76=41=16.37|4=14.76
9916.37=1|14.76=41=16.37|4=14.76
10016.37=1|14.76=41=16.37|4=14.76
10117.88=1|16.08=501=17.88|50=16.08
10222.24=1|20.02=561=22.24|56=20.02
10312.23=1|11.02=121=12.23|12=11.02
1042.05=1|1.85=1001=2.05|100=1.85
1052.05=1|1.85=1001=2.05|100=1.85
1061.66=1|1.5=1001=1.66|100=1.5
1071.66=1|1.5=1001=1.66|100=1.5
1081.66=1|1.5=1001=1.66|100=1.5
1091.66=1|1.5=1001=1.66|100=1.5
1101.66=1|1.5=1001=1.66|100=1.5
1111.66=1|1.5=1001=1.66|100=1.5
1121.66=1|1.5=1001=1.66|100=1.5
1131.66=1|1.5=1001=1.66|100=1.5
11416.49=1|14.91=101=16.49|10=14.91
11516.49=1|14.91=101=16.49|10=14.91
11616.49=1|14.91=101=16.49|10=14.91
11716.49=1|14.91=101=16.49|10=14.91
11816.49=1|14.91=101=16.49|10=14.91
11916.49=1|14.91=101=16.49|10=14.91
12016.49=1|14.91=101=16.49|10=14.91
12116.49=1|14.91=101=16.49|10=14.91
1228.99=1|8.08=101=8.99|10=8.08
1234.64=1|4.18=501=4.64|50=4.18
1245.73=1|5.13=501=5.73|50=5.13
1258.13=1|7.31=201=8.13|20=7.31
1267.13=1|6.42=201=7.13|20=6.42
12710.07=1|9.05=201=10.07|20=9.05
1289.02=1|8.13=201=9.02|20=8.13
1292.43=1|1.78=11=2.43|1=1.78
1301.78=11=1.78
1318.74=1|7.88=201=8.74|20=7.88
1329.56=1|8.62=201=9.56|20=8.62
1339.56=1|8.62=201=9.56|20=8.62
1346.4=1|5.77=51=6.4|5=5.77
1356.67=1|6.01=51=6.67|5=6.01
1366.67=1|6.01=51=6.67|5=6.01
1376.33=1|5.7=201=6.33|20=5.7
1387.86=1|7.07=201=7.86|20=7.07
1396.33=1|5.7=201=6.33|20=5.7
1406.67=1|6.01=201=6.67|20=6.01
1417.86=1|7.07=201=7.86|20=7.07
1424.9=1|4.41=201=4.9|20=4.41
1434.9=1|4.41=201=4.9|20=4.41
14431.5=35|25.99=65|22.5=130|20.99=32535=31.5|65=25.99|130=22.5|325=20.99
14540.41=1|31.99=50|29.99=100|28.5=2501=40.41|50=31.99|100=29.99|250=28.5
14636.5=1|32.86=101=36.5|10=32.86
1470.79=1|0.62=2201=0.79|220=0.62
14837.65=10|33.9=6010=37.65|60=33.9
1498.62=1|7.76=10|5.59=150|5.33=3001=8.62|10=7.76|150=5.59|300=5.33
1508.62=1|7.76=10|5.95=150|5.67=3001=8.62|10=7.76|150=5.95|300=5.67
1519.09=1|8.2=10|6.56=150|6.25=3001=9.09|10=8.2|150=6.56|300=6.25
1528.62=1|7.76=10|6.14=150|5.85=3001=8.62|10=7.76|150=6.14|300=5.85
1537.56=1|6.71=10|6.15=501=7.56|10=6.71|50=6.15
15470.03=11=70.03
155141.61=11=141.61
156151.23=11=151.23
15797.01=11=97.01
158118.21=11=118.21
159125.73=11=125.73
160140.73=11=140.73
161155.72=11=155.72
162178.22=11=178.22
163200.71=11=200.71
1640.89=1|0.77=10001=0.89|1000=0.77
16510.5=79|10.1=158|9.8=39579=10.5|158=10.1|395=9.8
16610.7=75|10.4=150|9.99=37575=10.7|150=10.4|375=9.99
16722.36=50|21.23=100|20.78=25050=22.36|100=21.23|250=20.78
16826.53=40|25.21=80|24.66=20040=26.53|80=25.21|200=24.66
16936.99=35|35.99=70|34.99=17535=36.99|70=35.99|175=34.99
1709=1|8.39=101=9|10=8.39
17123.51=1|19.59=61=23.51|6=19.59
17254.35=1|46.88=81=54.35|8=46.88
1737.49=75|6.5=150|6.19=300|5.98=75075=7.49|150=6.5|300=6.19|750=5.98
17438.58=1|34.72=321=38.58|32=34.72
1757.9=12|7.02=24|6.33=60|5.96=12012=7.9|24=7.02|60=6.33|120=5.96
17633.57=1|30.41=51=33.57|5=30.41
1776.03=1|5.42=121=6.03|12=5.42
1786.03=1|5.42=121=6.03|12=5.42
17922.87=1|20.58=321=22.87|32=20.58
1802.58=1|2.35=181=2.58|18=2.35
1815.57=1|5.29=121=5.57|12=5.29
1826.63=8|5.98=16|5.48=32|4.98=488=6.63|16=5.98|32=5.48|48=4.98
1832.97=1|2.67=181=2.97|18=2.67
1847.39=8|6.72=16|6.16=32|5.6=488=7.39|16=6.72|32=6.16|48=5.6
18514.6=1|13.13=701=14.6|70=13.13
1862.6=1|2.33=101=2.6|10=2.33
1876.02=1|5.42=101=6.02|10=5.42
188103.29=1|90.52=31=103.29|3=90.52
18957.48=1|51.73=31=57.48|3=51.73
19058.04=11=58.04
191119.09=1|107.16=31=119.09|3=107.16
19258.04=11=58.04
19358.04=11=58.04
19413.09=1|11.79=21=13.09|2=11.79
195245.72=1|219.4=31=245.72|3=219.4
196258.77=1|231.07=31=258.77|3=231.07
197306.62=1|273.76=31=306.62|3=273.76
198258.77=1|231.07=31=258.77|3=231.07
199271.82=1|242.7=31=271.82|3=242.7
200319.66=1|285.42=31=319.66|3=285.42
20122.44=1|20.19=101=22.44|10=20.19
20227.44=1|24.71=101=27.44|10=24.71
203128.8=1|119.14=31=128.8|3=119.14
20419.96=1|18.46=101=19.96|10=18.46
20516.74=1|15.48=101=16.74|10=15.48
2067.94=11=7.94
2077.94=11=7.94
20858.05=1|51.73=31=58.05|3=51.73
20958.05=1|51.73=31=58.05|3=51.73
21091.26=1|79.85=31=91.26|3=79.85
211106.26=1|95.64=31=106.26|3=95.64
212148.36=1|127.18=51=148.36|5=127.18
213156.3=1|133.98=51=156.3|5=133.98
214178.95=1|153.38=51=178.95|5=153.38
215172.15=1|147.56=51=172.15|5=147.56
216174.74=1|152.9=51=174.74|5=152.9
2176.88=1|6.2=301=6.88|30=6.2
218122.61=1|110.24=31=122.61|3=110.24
2196.18=1|5.55=101=6.18|10=5.55
2206.18=1|5.55=101=6.18|10=5.55
22110.51=1|9.45=101=10.51|10=9.45
2229.23=1|8.3=101=9.23|10=8.3
22311.49=1|10.35=101=11.49|10=10.35
22416.84=1|15.18=101=16.84|10=15.18
22523.31=1|20.97=101=23.31|10=20.97
22627.14=1|24.44=101=27.14|10=24.44
22735.48=1|31.93=101=35.48|10=31.93
22842.47=1|38.21=101=42.47|10=38.21
22962.38=1|56.15=101=62.38|10=56.15
23038.18=1|36.27=5|34.36=101=38.18|5=36.27|10=34.36
23139.87=1|37.88=5|35.72=101=39.87|5=37.88|10=35.72
23210.53=1|9.49=101=10.53|10=9.49
23311.46=1|10.31=10|8.25=201=11.46|10=10.31|20=8.25
23413.66=1|12.3=10|9.84=201=13.66|10=12.3|20=9.84
23517.16=1|15.44=101=17.16|10=15.44
23623.65=1|21.29=101=23.65|10=21.29
23726.65=1|23.99=101=26.65|10=23.99
23834.88=1|31.41=101=34.88|10=31.41
23962.92=1|56.62=101=62.92|10=56.62
24094.49=1|85.04=101=94.49|10=85.04
241116.61=1|104.97=101=116.61|10=104.97
24251.93=1|46.74=101=51.93|10=46.74
24360.57=1|54.51=101=60.57|10=54.51
24469.24=1|62.32=101=69.24|10=62.32
2453.45=1|3.09=101=3.45|10=3.09
2463.45=1|3.09=101=3.45|10=3.09
2473.45=1|3.09=101=3.45|10=3.09
2483.45=1|3.09=101=3.45|10=3.09
2493.45=1|3.09=101=3.45|10=3.09
2503.45=1|3.09=101=3.45|10=3.09
2516.1=150|5.78=300|5.35=750150=6.1|300=5.78|750=5.35
2529.03=1|8.14=100|7.49=5001=9.03|100=8.14|500=7.49
25366.6=11=66.6
25424.76=11=24.76
25537.12=11=37.12
25661.89=11=61.89
25774.27=11=74.27
25894.31=11=94.31
259148.53=11=148.53
260198.05=11=198.05
261247.56=11=247.56
262297.1=11=297.1
2634.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2644.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2654.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2664.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2674.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2684.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2694.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2704.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2714.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2724.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2734.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2744.23=1|3.8=50 |3.33=100|2.92=1501=4.23|50 =3.8|100=3.33|150=2.92
2754.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2764.23=1|3.79=25|3.16=1001=4.23|25=3.79|100=3.16
2776.04=1|5.43=251=6.04|25=5.43
2784.23=1|3.79=25|3.16=1001=4.23|25=3.79|100=3.16
2794.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2804.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2814.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2824.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2834.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2844.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2854.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2864.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2874.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2884.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2894.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2904.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
2915.83=1|5.26=51=5.83|5=5.26
2925.83=1|5.26=51=5.83|5=5.26
2935.83=1|5.26=51=5.83|5=5.26
2945.83=1|5.26=51=5.83|5=5.26
2955.83=1|5.26=51=5.83|5=5.26
2965.83=1|5.26=51=5.83|5=5.26
2975.83=1|5.26=51=5.83|5=5.26
2985.83=1|5.26=51=5.83|5=5.26
2995.83=1|5.26=51=5.83|5=5.26
3005.83=1|5.26=51=5.83|5=5.26
3015.83=1|5.26=51=5.83|5=5.26
3025.83=1|5.26=51=5.83|5=5.26
3035.83=1|5.26=51=5.83|5=5.26
3045.83=1|5.26=51=5.83|5=5.26
3055.83=1|5.26=51=5.83|5=5.26
3065.83=1|5.26=51=5.83|5=5.26
3075.83=1|5.26=51=5.83|5=5.26
3085.83=1|5.26=51=5.83|5=5.26
3095.83=1|5.26=51=5.83|5=5.26
3105.83=1|5.26=51=5.83|5=5.26
3115.83=1|5.26=51=5.83|5=5.26
3120.91=1|0.82=1001=0.91|100=0.82
3130.98=1|0.86=1001=0.98|100=0.86
3141.08=1|0.96=1001=1.08|100=0.96
3150.92=1|0.83=1001=0.92|100=0.83
3161.05=1|0.93=1001=1.05|100=0.93
3171.11=1|1=1001=1.11|100=1
3186.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3196.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3206.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3216.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3225.83=1|5.26=51=5.83|5=5.26
3235.83=1|5.26=51=5.83|5=5.26
3246.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3256.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3265.83=1|5.26=51=5.83|5=5.26
3275.83=1|5.26=51=5.83|5=5.26
3286.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3296.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3305.83=1|5.26=51=5.83|5=5.26
3315.83=1|5.26=51=5.83|5=5.26
3326.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3336.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3345.83=1|5.26=51=5.83|5=5.26
3355.83=1|5.26=51=5.83|5=5.26
3365.31=1|4.77=51=5.31|5=4.77
3375.31=1|4.77=51=5.31|5=4.77
3386.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3396.64=1|5.97=20|5.36=501=6.64|20=5.97|50=5.36
3405.83=1|5.26=51=5.83|5=5.26
3415.83=1|5.26=51=5.83|5=5.26
3426.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3436.04=1|4.87=50|4.39=1001=6.04|50=4.87|100=4.39
3445.31=1|4.77=51=5.31|5=4.77
3455.31=1|4.77=51=5.31|5=4.77
3464.23=1|3.8=50|3.33=100|2.92=1501=4.23|50=3.8|100=3.33|150=2.92
3474.23=1|3.8=50|3.33=100|2.92=1501=4.23|50=3.8|100=3.33|150=2.92
3484.23=1|3.8=50|3.33=100|2.92=1501=4.23|50=3.8|100=3.33|150=2.92
3493.09=1|2.78=51=3.09|5=2.78
3503.09=1|2.78=51=3.09|5=2.78
3513.09=1|2.78=51=3.09|5=2.78
3525.6=1|5.03=201=5.6|20=5.03
3535.6=1|5.03=201=5.6|20=5.03
35415.53=1|13.99=101=15.53|10=13.99
3550.78=1|0.71=1001=0.78|100=0.71
3560.98=1|0.86=1001=0.98|100=0.86
3571.11=1|1=1001=1.11|100=1
3581.11=1|1=1001=1.11|100=1
3590.98=1|0.86=1001=0.98|100=0.86
3601.16=1|1.03=1001=1.16|100=1.03
3611.28=1|1.17=1001=1.28|100=1.17
3620.98=1|0.86=1001=0.98|100=0.86
3631.16=1|1.03=1001=1.16|100=1.03
36421.58=1|19.41=201=21.58|20=19.41
36521.58=1|19.41=201=21.58|20=19.41
36621.58=1|19.41=201=21.58|20=19.41
36721.58=1|19.41=201=21.58|20=19.41
36821.58=1|19.41=201=21.58|20=19.41
36921.58=1|19.41=201=21.58|20=19.41
3707.75=1|6.97=51=7.75|5=6.97
3717.35=1|6.62=51=7.35|5=6.62
3727.35=1|6.62=51=7.35|5=6.62
373186.19=11=186.19
374214.32=11=214.32
375234.9=11=234.9
376254.36=11=254.36
377273.85=11=273.85
378314.98=11=314.98
379353.97=11=353.97
38016.23=11=16.23
38146.54=11=46.54
382110.4=11=110.4
383120.15=11=120.15
384180.76=11=180.76
38520.19=1|18.17=61=20.19|6=18.17
386316.73=1|291.39=31=316.73|3=291.39
38761.17=11=61.17
38885.08=11=85.08
389107.76=11=107.76
390135.04=11=135.04
391153.34=11=153.34
392173.27=11=173.27
393189.87=11=189.87
394238.72=11=238.72
395258.51=11=258.51
396286.94=11=286.94
397323.09=11=323.09
398340.26=11=340.26
399410.52=11=410.52
400495.21=11=495.21
401526.01=11=526.01
40236.19=11=36.19
403149.48=11=149.48
404122.61=1|110.24=61=122.61|6=110.24
40551.15=11=51.15
406211.22=11=211.22
407422.43=11=422.43
40841.1=1|37.81=51=41.1|5=37.81
40924.83=1|22.2=51=24.83|5=22.2
4105.17=1|4.64=121=5.17|12=4.64
41166.38=11=66.38
412117.9=1|98.25=31=117.9|3=98.25
413183.39=1|157.19=31=183.39|3=157.19
414117.9=1|98.26=31=117.9|3=98.26
415183.39=1|157.19=91=183.39|9=157.19
416654.34=11=654.34
417294.08=11=294.08
4187.3=12|6.53=24|5.59=6012=7.3|24=6.53|60=5.59
41921.14=1|19.01=6|16.93=481=21.14|6=19.01|48=16.93
42010.09=1|8.77=6|7.74=121=10.09|6=8.77|12=7.74
42114.85=1|12.92=6|12.39=121=14.85|6=12.92|12=12.39
4227.84=1|7.2=101=7.84|10=7.2
4235.24=20|5.03=200|4.84=100020=5.24|200=5.03|1000=4.84
4249.68=100|8.75=320|7.84=960100=9.68|320=8.75|960=7.84
4251.95=500|1.64=2000|1.42=6000500=1.95|2000=1.64|6000=1.42
4269.15=24|7.84=96|7.32=24024=9.15|96=7.84|240=7.32
42758.96=2|51.09=10|47.03=1642=58.96|10=51.09|164=47.03
42878.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
4291.64=1|1.25=1000|1.17=3000|1.05=60001=1.64|1000=1.25|3000=1.17|6000=1.05
430286.44=1|276.42=51=286.44|5=276.42
4319.15=24|7.84=48|6.53=9624=9.15|48=7.84|96=6.53
43278.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
43315.39=1|14.61=101=15.39|10=14.61
43478.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
43578.58=1|73.34=5|72.04=101=78.58|5=73.34|10=72.04
436238.03=1|226.13=51=238.03|5=226.13
437168.98=1|152.09=51=168.98|5=152.09
438144.08=1|137.52=51=144.08|5=137.52
439370.61=1|357.65=51=370.61|5=357.65
44015.71=1010=15.71
44115.71=1010=15.71
442155.89=1|142.78=51=155.89|5=142.78
44310.8=1|9.1=12|8.06=241=10.8|12=9.1|24=8.06
4446.22=12|5.24=2412=6.22|24=5.24
44513.43=50|13.09=100|12.45=25050=13.43|100=13.09|250=12.45
44613.43=50|13.09=100|12.45=25050=13.43|100=13.09|250=12.45
44713.43=50|13.09=100|12.45=25050=13.43|100=13.09|250=12.45
448332.75=1|313.09=31=332.75|3=313.09
449332.75=1|313.09=31=332.75|3=313.09
4505.85=11=5.85
4514.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4524.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4534.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4544.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4554.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4564.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4574.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4584.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4594.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4604.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4614.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
4624.84=1|4.15=25|3.45=1001=4.84|25=4.15|100=3.45
46320.15=1|17.47=501=20.15|50=17.47
46424.01=1|20.15=401=24.01|40=20.15
465220.29=00=220.29
46623.02=00=23.02
46741.74=00=41.74
46827.35=00=27.35
46921.59=00=21.59
4708.68=1|7.6=12|6.71=241=8.68|12=7.6|24=6.71
4717.73=1|7.27=12|6.71=241=7.73|12=7.27|24=6.71
472485.97=11=485.97
473902.21=11=902.21
474232.47=11=232.47
47515=1|12.41=12|11.75=241=15|12=12.41|24=11.75
4769.99=7575=9.99
47712.87=1|12.31=121=12.87|12=12.31
4783.24=1|0.75=1000|0.6=100001=3.24|1000=0.75|10000=0.6
47935.79=85|32.79=170|31=25585=35.79|170=32.79|255=31
480152.73=11=152.73
481173.23=11=173.23
482408.98=11=408.98
483562.73=11=562.73
484179.38=11=179.38
4851331.48=11=1331.48
4862.2=1000|2=20001000=2.2|2000=2
48725=11=25
48845=11=45
48910.83=1|9.84=5|8.4=101=10.83|5=9.84|10=8.4
490460.23=1|408.98=3|378.23=61=460.23|3=408.98|6=378.23
49111=1|10.38=7|10.16=35|9.64=701=11|7=10.38|35=10.16|70=9.64
49219.45=1|18.43=7|17.4=35|16.38=701=19.45|7=18.43|35=17.4|70=16.38
49329.61=3535=29.61
49413.66=1|12.3=10|9.84=201=13.66|10=12.3|20=9.84
49517.16=1|15.44=101=17.16|10=15.44
49626.65=1|23.99=101=26.65|10=23.99
49717.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
49817.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
49917.26=1|15.54=10|12.43=201=17.26|10=15.54|20=12.43
50018.7=1|17.51=10|16.91=201=18.7|10=17.51|20=16.91
50127.51=1|24.76=101=27.51|10=24.76
50211.79=1|9.74=10|8.68=201=11.79|10=9.74|20=8.68
5037.01=1|5.59=401=7.01|40=5.59
5046.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
5056.36=1|5.52=12|5.26=361=6.36|12=5.52|36=5.26
50615.95=1|13.87=12|13.27=361=15.95|12=13.87|36=13.27
50717.02=1|8.62=40|7.98=1201=17.02|40=8.62|120=7.98
50848.91=1|45.74=8|41.17=20|37.05=401=48.91|8=45.74|20=41.17|40=37.05
Sheet4
Cell Formulas
RangeFormula
B2:B508B2=BYROW(A2:A508,LAMBDA(br,TEXTJOIN({"=","|"},,CHOOSECOLS(TEXTSPLIT(br,"=","|"),2,1))))
Dynamic array formulas.
Fantastic, thank you very much. I have sent that to my colleague. Thank you again!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

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