How to sort in excel i have folowing data and i want highlighted columns can be sorted?

[trustmeasfrnd]

i want to sort corresponding to column O and T using macro button for ascending/descending values. the problem is my column A has Plate mark only for one case till all load cases changes. how to add plate mark in all rows(may be needed another excel Macro button to do that)
Also note that row can be more than shown here.
one more help needed can i reduce using formula for columns K L M N O and P Q R S T and rows as same formula is repeted?

Thanks in Advance.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
	Shear	Membrane	Bending Moment
Plate	L/C	SQX (local) N/mm2	SQY (local) N/mm2	SX (local) N/mm2	SY (local) N/mm2	SXY (local) N/mm2	Mx1	My1	Mx2	My2	Mxd	Mx1	My1	Mx2	My2	Mxd
301 1.5DL1 + 1.5LL
302 1.2DL1 + 1.2LL + 1.2WLX (W-E)
303 1.2DL1 + 1.2LL - 1.2WLX (W-E)
304 1.2DL1 + 1.2LL + 1.2WLZ (N-S)
305 1.2DL1 + 1.2LL - 1.2WLZ (N-S)
310 1.5DL1 + 1.5WLX (W-E)
301 1.5DL1 + 1.5LL
302 1.2DL1 + 1.2LL + 1.2WLX (W-E)
303 1.2DL1 + 1.2LL - 1.2WLX (W-E)
304 1.2DL1 + 1.2LL + 1.2WLZ (N-S)
305 1.2DL1 + 1.2LL - 1.2WLZ (N-S)
301 1.5DL1 + 1.5LL
302 1.2DL1 + 1.2LL + 1.2WLX (W-E)
303 1.2DL1 + 1.2LL - 1.2WLX (W-E)
304 1.2DL1 + 1.2LL + 1.2WLZ (N-S)
305 1.2DL1 + 1.2LL - 1.2WLZ (N-S)
301 1.5DL1 + 1.5LL
302 1.2DL1 + 1.2LL + 1.2WLX (W-E)
303 1.2DL1 + 1.2LL - 1.2WLX (W-E)
304 1.2DL1 + 1.2LL + 1.2WLZ (N-S)
305 1.2DL1 + 1.2LL - 1.2WLZ (N-S)

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Mxd For TOP REINFORCEMENT[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Mxd For BOTTOM REINFORCEMENT[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]Mx kNm/m[/TD]
[TD="align: center"]My kNm/m[/TD]
[TD="align: center"]Mxy kNm/m[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1422[/TD]

[TD="align: right"]0.016[/TD]
[TD="align: right"]0.028[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]-0.183[/TD]
[TD="align: right"]6.739[/TD]
[TD="align: right"]0.039[/TD]
[TD="align: right"]-0.144[/TD]
[TD="align: right"]6.778[/TD]
[TD="align: right"]-0.18277[/TD]
[TD="align: right"]6.747311[/TD]
[TD="align: right"]0.000[/TD]
[TD="align: right"]-0.222[/TD]
[TD="align: right"]6.7[/TD]
[TD="align: right"]-0.18323[/TD]
[TD="align: right"]6.730689[/TD]
[TD="align: right"]-0.183[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.024[/TD]
[TD="align: right"]0.033[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-1.071[/TD]
[TD="align: right"]7.951[/TD]
[TD="align: right"]0.552[/TD]
[TD="align: right"]-0.519[/TD]
[TD="align: right"]8.503[/TD]
[TD="align: right"]-1.03268[/TD]
[TD="align: right"]8.235504[/TD]
[TD="align: right"]0.000[/TD]
[TD="align: right"]-1.623[/TD]
[TD="align: right"]7.399[/TD]
[TD="align: right"]-1.10932[/TD]
[TD="align: right"]7.666496[/TD]
[TD="align: right"]-1.109[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.001[/TD]
[TD="align: right"]0.011[/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.799[/TD]
[TD="align: right"]2.813[/TD]
[TD="align: right"]-0.489[/TD]
[TD="align: right"]1.288[/TD]
[TD="align: right"]3.302[/TD]
[TD="align: right"]0.884006[/TD]
[TD="align: right"]3.112275[/TD]
[TD="align: right"]1.288[/TD]
[TD="align: right"]0.31[/TD]
[TD="align: right"]2.324[/TD]
[TD="align: right"]0.713994[/TD]
[TD="align: right"]2.513725[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.011[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]-0.171[/TD]
[TD="align: right"]4.031[/TD]
[TD="align: right"]-0.705[/TD]
[TD="align: right"]0.534[/TD]
[TD="align: right"]4.736[/TD]
[TD="align: right"]-0.0477[/TD]
[TD="align: right"]6.937579[/TD]
[TD="align: right"]0.534[/TD]
[TD="align: right"]-0.876[/TD]
[TD="align: right"]3.326[/TD]
[TD="align: right"]-0.2943[/TD]
[TD="align: right"]1.124421[/TD]
[TD="align: right"]-0.294[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.014[/TD]
[TD="align: right"]0.024[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]-0.07[/TD]
[TD="align: right"]6.806[/TD]
[TD="align: right"]0.811[/TD]
[TD="align: right"]0.741[/TD]
[TD="align: right"]7.617[/TD]
[TD="align: right"]0.026638[/TD]
[TD="align: right"]16.20201[/TD]
[TD="align: right"]0.741[/TD]
[TD="align: right"]-0.881[/TD]
[TD="align: right"]5.995[/TD]
[TD="align: right"]-0.16664[/TD]
[TD="align: right"]-2.59001[/TD]
[TD="align: right"]-0.167[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.029[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-1.266[/TD]
[TD="align: right"]9.638[/TD]
[TD="align: right"]0.595[/TD]
[TD="align: right"]-0.671[/TD]
[TD="align: right"]10.233[/TD]
[TD="align: right"]-1.22927[/TD]
[TD="align: right"]9.917641[/TD]
[TD="align: right"]0.000[/TD]
[TD="align: right"]-1.861[/TD]
[TD="align: right"]9.043[/TD]
[TD="align: right"]-1.30273[/TD]
[TD="align: right"]9.358359[/TD]
[TD="align: right"]-1.303[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]1419[/TD]

[TD="align: right"]0.03[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]1.289[/TD]
[TD="align: right"]76.493[/TD]
[TD="align: right"]1.941[/TD]
[TD="align: right"]3.23[/TD]
[TD="align: right"]78.434[/TD]
[TD="align: right"]1.338253[/TD]
[TD="align: right"]79.41579[/TD]
[TD="align: right"]3.230[/TD]
[TD="align: right"]-0.652[/TD]
[TD="align: right"]74.552[/TD]
[TD="align: right"]1.239747[/TD]
[TD="align: right"]73.57021[/TD]
[TD="align: right"]1.240[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.037[/TD]
[TD="align: right"]0.047[/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"]-0.002[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]-0.214[/TD]
[TD="align: right"]88.563[/TD]
[TD="align: right"]3.244[/TD]
[TD="align: right"]3.03[/TD]
[TD="align: right"]91.807[/TD]
[TD="align: right"]-0.09517[/TD]
[TD="align: right"]137.7384[/TD]
[TD="align: right"]3.030[/TD]
[TD="align: right"]-3.458[/TD]
[TD="align: right"]85.319[/TD]
[TD="align: right"]-0.33283[/TD]
[TD="align: right"]39.3876[/TD]
[TD="align: right"]-0.333[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.011[/TD]
[TD="align: right"]0.032[/TD]
[TD="align: right"]0.003[/TD]
[TD="align: right"]0.003[/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"]2.314[/TD]
[TD="align: right"]33.214[/TD]
[TD="align: right"]-0.021[/TD]
[TD="align: right"]2.335[/TD]
[TD="align: right"]33.235[/TD]
[TD="align: right"]2.314013[/TD]
[TD="align: right"]33.21419[/TD]
[TD="align: right"]2.335[/TD]
[TD="align: right"]2.293[/TD]
[TD="align: right"]33.193[/TD]
[TD="align: right"]2.313987[/TD]
[TD="align: right"]33.21381[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.026[/TD]
[TD="align: right"]0.036[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]-0.422[/TD]
[TD="align: right"]52.257[/TD]
[TD="align: right"]-2.346[/TD]
[TD="align: right"]1.924[/TD]
[TD="align: right"]54.603[/TD]
[TD="align: right"]-0.31668[/TD]
[TD="align: right"]65.29898[/TD]
[TD="align: right"]1.924[/TD]
[TD="align: right"]-2.768[/TD]
[TD="align: right"]49.911[/TD]
[TD="align: right"]-0.52732[/TD]
[TD="align: right"]39.21502[/TD]
[TD="align: right"]-0.527[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.022[/TD]
[TD="align: right"]0.043[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"]2.485[/TD]
[TD="align: right"]70.812[/TD]
[TD="align: right"]5.661[/TD]
[TD="align: right"]8.146[/TD]
[TD="align: right"]76.473[/TD]
[TD="align: right"]2.937563[/TD]
[TD="align: right"]83.70815[/TD]
[TD="align: right"]8.146[/TD]
[TD="align: right"]-3.176[/TD]
[TD="align: right"]65.151[/TD]
[TD="align: right"]2.032437[/TD]
[TD="align: right"]57.91585[/TD]
[TD="align: right"]2.032[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]1417[/TD]

[TD="align: right"]-0.055[/TD]
[TD="align: right"]-0.207[/TD]
[TD="align: right"]0.008[/TD]
[TD="align: right"]-0.008[/TD]
[TD="align: right"]0.004[/TD]
[TD="align: right"]11.552[/TD]
[TD="align: right"]107.016[/TD]
[TD="align: right"]9.602[/TD]
[TD="align: right"]21.154[/TD]
[TD="align: right"]116.618[/TD]
[TD="align: right"]12.41354[/TD]
[TD="align: right"]114.9972[/TD]
[TD="align: right"]21.154[/TD]
[TD="align: right"]1.95[/TD]
[TD="align: right"]97.414[/TD]
[TD="align: right"]10.69046[/TD]
[TD="align: right"]99.03484[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]

[TD="align: right"]-0.049[/TD]
[TD="align: right"]-0.188[/TD]
[TD="align: right"]0.006[/TD]
[TD="align: right"]-0.01[/TD]
[TD="align: right"]0.007[/TD]
[TD="align: right"]9.38[/TD]
[TD="align: right"]126.213[/TD]
[TD="align: right"]7.369[/TD]
[TD="align: right"]16.749[/TD]
[TD="align: right"]133.582[/TD]
[TD="align: right"]9.810242[/TD]
[TD="align: right"]132.0021[/TD]
[TD="align: right"]16.749[/TD]
[TD="align: right"]2.011[/TD]
[TD="align: right"]118.844[/TD]
[TD="align: right"]8.949758[/TD]
[TD="align: right"]120.4239[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]

[TD="align: right"]-0.039[/TD]
[TD="align: right"]-0.143[/TD]
[TD="align: right"]0.006[/TD]
[TD="align: right"]-0.003[/TD]
[TD="align: right"]-0.002[/TD]
[TD="align: right"]9.102[/TD]
[TD="align: right"]43.973[/TD]
[TD="align: right"]8.186[/TD]
[TD="align: right"]17.288[/TD]
[TD="align: right"]52.159[/TD]
[TD="align: right"]10.6259[/TD]
[TD="align: right"]51.33518[/TD]
[TD="align: right"]17.288[/TD]
[TD="align: right"]0.916[/TD]
[TD="align: right"]35.787[/TD]
[TD="align: right"]7.578097[/TD]
[TD="align: right"]36.61082[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]

[TD="align: right"]-0.034[/TD]
[TD="align: right"]-0.169[/TD]
[TD="align: right"]0.006[/TD]
[TD="align: right"]-0.014[/TD]
[TD="align: right"]0.004[/TD]
[TD="align: right"]7.062[/TD]
[TD="align: right"]54.59[/TD]
[TD="align: right"]5.994[/TD]
[TD="align: right"]13.056[/TD]
[TD="align: right"]60.584[/TD]
[TD="align: right"]7.720143[/TD]
[TD="align: right"]59.67752[/TD]
[TD="align: right"]13.056[/TD]
[TD="align: right"]1.068[/TD]
[TD="align: right"]48.596[/TD]
[TD="align: right"]6.403857[/TD]
[TD="align: right"]49.50248[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]

[TD="align: right"]-0.054[/TD]
[TD="align: right"]-0.162[/TD]
[TD="align: right"]0.006[/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"]0.002[/TD]
[TD="align: right"]11.401[/TD]
[TD="align: right"]117.266[/TD]
[TD="align: right"]9.541[/TD]
[TD="align: right"]20.942[/TD]
[TD="align: right"]126.807[/TD]
[TD="align: right"]12.17728[/TD]
[TD="align: right"]125.2504[/TD]
[TD="align: right"]20.942[/TD]
[TD="align: right"]1.86[/TD]
[TD="align: right"]107.725[/TD]
[TD="align: right"]10.62472[/TD]
[TD="align: right"]109.2816[/TD]
[TD="align: right"]0.000[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]1413[/TD]

[TD="align: right"]0.035[/TD]
[TD="align: right"]-0.033[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-2.346[/TD]
[TD="align: right"]3.922[/TD]
[TD="align: right"]2.584[/TD]
[TD="align: right"]0.238[/TD]
[TD="align: right"]6.506[/TD]
[TD="align: right"]-0.64354[/TD]
[TD="align: right"]6.768145[/TD]
[TD="align: right"]0.238[/TD]
[TD="align: right"]-4.93[/TD]
[TD="align: right"]1.338[/TD]
[TD="align: right"]-4.04846[/TD]
[TD="align: right"]1.075855[/TD]
[TD="align: right"]-4.048[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.047[/TD]
[TD="align: right"]-0.044[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-3.632[/TD]
[TD="align: right"]6.854[/TD]
[TD="align: right"]1.358[/TD]
[TD="align: right"]-2.274[/TD]
[TD="align: right"]8.212[/TD]
[TD="align: right"]-3.36294[/TD]
[TD="align: right"]7.361754[/TD]
[TD="align: right"]0.000[/TD]
[TD="align: right"]-4.99[/TD]
[TD="align: right"]5.496[/TD]
[TD="align: right"]-3.90106[/TD]
[TD="align: right"]6.346246[/TD]
[TD="align: right"]-3.901[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.009[/TD]
[TD="align: right"]-0.008[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.097[/TD]
[TD="align: right"]-0.707[/TD]
[TD="align: right"]2.818[/TD]
[TD="align: right"]2.721[/TD]
[TD="align: right"]2.111[/TD]
[TD="align: right"]11.13514[/TD]
[TD="align: right"]81.16026[/TD]
[TD="align: right"]2.721[/TD]
[TD="align: right"]-2.915[/TD]
[TD="align: right"]-3.525[/TD]
[TD="align: right"]-11.3291[/TD]
[TD="align: right"]-82.5743[/TD]
[TD="align: right"]-2.915[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.024[/TD]
[TD="align: right"]-0.028[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]-1.929[/TD]
[TD="align: right"]3.882[/TD]
[TD="align: right"]3.076[/TD]
[TD="align: right"]1.147[/TD]
[TD="align: right"]6.958[/TD]
[TD="align: right"]0.508346[/TD]
[TD="align: right"]8.787016[/TD]
[TD="align: right"]1.147[/TD]
[TD="align: right"]-5.005[/TD]
[TD="align: right"]0.806[/TD]
[TD="align: right"]-4.36635[/TD]
[TD="align: right"]-1.02302[/TD]
[TD="align: right"]-4.366[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.031[/TD]
[TD="align: right"]-0.025[/TD]
[TD="align: right"]-0.001[/TD]
[TD="align: right"]0.001[/TD]
[TD="align: right"]-0.002[/TD]
[TD="align: right"]-1.837[/TD]
[TD="align: right"]2.41[/TD]
[TD="align: right"]1.055[/TD]
[TD="align: right"]-0.782[/TD]
[TD="align: right"]3.465[/TD]
[TD="align: right"]-1.37516[/TD]
[TD="align: right"]3.015893[/TD]
[TD="align: right"]0.000[/TD]
[TD="align: right"]-2.892[/TD]
[TD="align: right"]1.355[/TD]
[TD="align: right"]-2.29884[/TD]
[TD="align: right"]1.804107[/TD]
[TD="align: right"]-2.299[/TD]

</tbody>

Cenrral Force for MY​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="width: 10"]K3[/TH]
[TD="align: left"]=H3+ABS(J3)[/TD]
[/TR]
[TR]
[TH="width: 10"]L3[/TH]
[TD="align: left"]=I3+ABS(J3)[/TD]
[/TR]
[TR]
[TH="width: 10"]M3[/TH]
[TD="align: left"]=H3+ABS(J3^2/I3)[/TD]
[/TR]
[TR]
[TH="width: 10"]N3[/TH]
[TD="align: left"]=I3+ABS(J3^2/H3)[/TD]
[/TR]
[TR]
[TH="width: 10"]O3[/TH]
[TD="align: left"]=IF(AND(K3>0,L3>0),K3,IF(AND(K3<0,L3<0),0,IF(AND(K3<0,L3>0),0,M3)))[/TD]
[/TR]
[TR]
[TH="width: 10"]P3[/TH]
[TD="align: left"]=H3-ABS(J3)[/TD]
[/TR]
[TR]
[TH="width: 10"]Q3[/TH]
[TD="align: left"]=I3-ABS(J3)[/TD]
[/TR]
[TR]
[TH="width: 10"]R3[/TH]
[TD="align: left"]=H3-ABS(J3^2/I3)[/TD]
[/TR]
[TR]
[TH="width: 10"]S3[/TH]
[TD="align: left"]=I3-ABS(J3^2/H3)[/TD]
[/TR]
[TR]
[TH="width: 10"]T3[/TH]
[TD="align: left"]=IF(AND(P3>0,Q3>0),0,IF(AND(P3<0,Q3<0),P3,IF(AND(P3<0,Q3>0),R3,0)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[trustmeasfrnd]

Hi, Fluff,
Thank you,it worked.
once again thank you for the help.
regards,
Abhisekh

 

[Fluff]

Glad to help & thanks for the feedback