Finding Maximum Depending on Multiple Conditions

[elgre]

Hello everyone,
I am trying to find maximum value of a range, depending on 2conditions, please see below.

For instance, what I am trying to do is,
- if L2 is Beam1, and M2 is Max Nxx, find the maximum value of D2:D9 (the Beam1 range for Nxx) and type into N2
- if L2 is Beam1, and M2 is Max Nxy, find the maximum value of E2:E9 (the Beam1 range for Nxy) and type into O2
- if L2 is Beam1, and M2 is Max Nxz, find the maximum value of F2:F9 (the Beam1 range for NxZ) and type into P2
- if L2 is Beam1, and M2 is Max Mxx, find the maximum value of G2:G9 (the Beam1 range for Nxx) and type into N2
- if L2 is Beam1, and M2 is Max Mxy, find the maximum value of H2:H9 (the Beam1 range for Nxy) and type into O2
- if L2 is Beam1, and M2 is Max Mxz, find the maximum value of I2I9 (the Beam1 range for NxZ) and type into P2

- if L2 is Beam1, and M2 is Max Nxx, find the minimum value of D2:D9 (the Beam1 range for Nxx) and type into N2
- if L2 is Beam1, and M2 is Max Nxy, find the minimum value of E2:E9 (the Beam1 range for Nxy) and type into O2
- if L2 is Beam1, and M2 is Max Nxz, find the minimum value of F2:F9 (the Beam1 range for NxZ) and type into P2
- if L2 is Beam1, and M2 is Max Mxx, find the minimum value of G2:G9 (the Beam1 range for Nxx) and type into N2
- if L2 is Beam1, and M2 is Max Mxy, find the minimum value of H2:H9 (the Beam1 range for Nxy) and type into O2
- if L2 is Beam1, and M2 is Max Mxz, find the minimum value of I2I9 (the Beam1 range for NxZ) and type into P2

- do these steps for L3, L4, L5 and so on until the data finishes in column A (L2,L3,L,4,... data depending on A column)

I tried to use index, max(if) as boolean logic but the formula got really complicated and did not give me the results I wanted.

I hope it is clear but please let me know if you need more explanation.

Any help from your side would be really appreciated. Thank you very much in advance.

 

[DanteAmor]

Check if this is what you need:

varios 18feb2022.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Name	pos	leng	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]					NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]
2	Beam1			755	752	316	486	312	404			Beam1	Max	755	768	571	766	726	794
3	Beam1			551	525	357	760	580	313			Beam1	Min	452	525	316	371	312	313
4	Beam1			647	757	457	732	592	794			Beam2	Max	789	772	780	749	780	774
5	Beam1			452	612	571	371	632	445			Beam2	Min	454	387	459	438	442	412
6	Beam1			594	768	563	718	432	502			Beam3	Max	684	741	707	719	703	712
7	Beam1			603	627	391	766	726	351			Beam3	Min	374	483	305	437	546	317
8	Beam1			678	549	356	480	712	731
9	Beam2			558	772	779	749	780	666
10	Beam2			454	681	780	663	549	412
11	Beam2			502	387	459	665	665	469
12	Beam2			787	763	690	465	442	492
13	Beam2			789	503	763	556	673	774
14	Beam2			657	615	648	438	468	652
15	Beam3			684	741	707	719	548	317
16	Beam3			376	483	579	437	576	712
17	Beam3			374	652	305	531	703	661
18	Beam3			649	721	377	521	546	543
Hoja2

Cell Formulas
Range	Formula
N2:S7	N2	=IF($M2="Max",MAX(IF($A$2:$A$18=$L2,IF($D$1:$I$1=N$1,$D$2:$I$18))),MIN(IF($A$2:$A$18=$L2,IF($D$1:$I$1=N$1,$D$2:$I$18))))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Peter_SSs]

Welcome to the MrExcel board!

For next time:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

- if L2 is Beam1, and M2 is Max Nxy, find the maximum value of E2:E9 (the Beam1 range for Nxy) and type into O2

A bit confusing. In your sample data, it looks like this value might actually be Nyx?

If so, perhaps it is more this sort of thing you are after?

22 02 19.xlsm
	A			D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Name			NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]					NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]
2	Beam1			755	752	316	486	312	404			Beam1	Max Nxx	755
3	Beam1			551	525	357	760	580	313			Beam1	Min Nxy		525
4	Beam1			647	757	457	732	592	794			Beam2	Max Mxx				749
5	Beam1			452	612	571	371	632	445			Beam2	Min Mxz						412
6	Beam1			594	768	563	718	432	502			Beam3	Max Mxy					703
7	Beam1			603	627	391	766	726	351			Beam3	Min Nxz			305
8	Beam1			678	549	356	480	712	731
9	Beam2			558	772	779	749	780	666
10	Beam2			454	681	780	663	549	412
11	Beam2			502	387	459	665	665	469
12	Beam2			787	763	690	465	442	492
13	Beam2			789	503	763	556	673	774
14	Beam2			657	615	648	438	468	652
15	Beam3			684	741	707	719	548	317
16	Beam3			376	483	579	437	576	712
17	Beam3			374	652	305	531	703	661
18	Beam3			649	721	377	521	546	543
Max Min

Cell Formulas
Range	Formula
N2:S7	N2	=IF(RIGHT($M2,3)=LEFT(N$1,3),AGGREGATE(IF(LEFT($M2,3)="Max",14,15),6,INDEX($D$2:$I$18,0,MATCH(N$1,$D$1:$I$1,0))/($A$2:$A$18=$L2),1),"")

 

[elgre]

Hi both,

Thank you very much for your responses and thanks for introducing XL2BB. I am quite new to here but I will definitely get myself familiar with more features!

I know, the thing I am trying to achieve is a bit complicated (even explaining!) but hopefully we can sort it out. I attached a simplified version of my workbook I am working on, where the cells are manually saved for the reference.

I hope it makes it a bit simpler.

Thank you very much again for your help.

Test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Name	Position	Length [m]	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]		Name	Load	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]
2	RP_Bm1	0	0	304.925	-844.201	-4012.25	-78.8421	304.925	328.703		RP_Bm1	Max Nxx	2514.330	-1329.07	-977.517	18.3758	-546.222	449.834		Find the 2514.330 in D:D, which is max value of Nxx for RP_Bm1 and write the rest of the data, highlighted in yellow. For instance for this row, it is on row210
3	RP_Bm1	1	0.725	415.847	-579.474	-3171.93	-78.8421	393.444	-187.331		RP_Bm1	Max Nxy	1674.620	-72.853	-3244.800	-97.997	-1766.250	275.349		Find the -72.853 in E:E, which is max value of Nxy for RP_Bm1 and write the rest of the data, highlighted in yellow. For instance for this row, it is on row156
4	RP_Bm1	0	0	304.925	-749.923	-4004.62	-78.915	-2205.39	310.541		RP_Bm1	Max Nxz			-721.100					Do this for RP_Bm10, RO_Bm103, and so on, continue until data finishes in column A:A
5	RP_Bm1	1	0.725	304.925	-513.525	-3164.3	-78.915	392.65	-147.416		RP_Bm1	Max Mxx				18.376
6	RP_Bm1	0	0	491.227	-579.67	-3980.92	-85.9569	-2187.9	303.333		RP_Bm1	Max Mxy					399.018
7	RP_Bm1	1	0.725	491.227	-440.064	-3140.59	-85.9569	392.957	-66.2948		RP_Bm1	Max Mxz						449.834
8	RP_Bm1	0	0	873.673	-380.372	-3954.64	-94.5345	-2167.93	294.966		RP_Bm1	Min Nxx	-34.312
9	RP_Bm1	1	0.725	873.673	-380.372	-3114.31	-94.5345	393.878	19.196		RP_Bm1	Min Nxy		-1446.400
10	RP_Bm1	0	0	1345.86	-212.968	-3931.27	-103.778	-2149.46	292.69		RP_Bm1	Min Nxz			-4012.250
11	RP_Bm1	1	0.725	1345.86	-351.575	-3090.95	-103.778	395.405	88.0184		RP_Bm1	Min Mxx				-114.185
12	RP_Bm1	0	0	1801.8	-133.639	-3916.45	-111.022	-2137.07	304.415		RP_Bm1	Min Mxy					-2209.500
13	RP_Bm1	1	0.725	1801.8	-370.254	-3076.13	-111.022	397.054	121.711		RP_Bm1	Min Mxz						-556.296
14	RP_Bm1	0	0	2129.11	-160.057	-3912.95	-114.041	-2133.4	325.863		RP_Bm10	Max Nxx
15	RP_Bm1	1	0.725	2129.11	-422.037	-3072.62	-114.041	398.181	114.806		RP_Bm10	Max Nxy
16	RP_Bm1	0	0	2234.21	-281.519	-3920.57	-112.989	-2138.22	348.731		RP_Bm10	Max Nxz
17	RP_Bm1	1	0.725	2234.21	-507.319	-3080.25	-112.989	398.894	62.7361		RP_Bm10	Max Mxx
18	RP_Bm1	0	0	2042.26	-469.123	-3942.31	-106.102	-2154.1	357.831		RP_Bm10	Max Mxy
19	RP_Bm1	1	0.725	2042.26	-599.863	-3101.99	-106.102	398.776	-29.7		RP_Bm10	Max Mxz
20	RP_Bm1	0	0	1589.84	-651.413	-3967.03	-99.606	-2172.49	359.884		RP_Bm10	Min Nxx
21	RP_Bm1	1	0.725	1589.84	-651.413	-3126.71	-99.606	398.301	-112.391		RP_Bm10	Min Nxy
22	RP_Bm1	0	0	1126.72	-766.254	-3990.02	-92.5375	-2190.49	354.177		RP_Bm10	Min Nxz
23	RP_Bm10	1	2.14739	1098.89	1455.37	-451.537	388.169	96.467	100.971		RP_Bm10	Min Mxx
24	RP_Bm10	0	0	-753.268	-127.788	1275.32	332.454	-480.992	109.534		RP_Bm10	Min Mxy
25	RP_Bm10	1	2.14739	879.373	700.826	-446.277	378.764	71.7518	155.566		RP_Bm10	Min Mxz
26	RP_Bm10	0	0	930.687	-145.602	390.093	146.17	-131.74	88.0633		RP_Bm103	Max Nxx
27	RP_Bm10	1	2.14739	464.855	-36.4774	-223.167	102.642	-15.4912	150.549		RP_Bm103	Max Nxy
28	RP_Bm10	0	0	1355.04	-199.505	534.882	149.668	-281.188	46.0798		RP_Bm103	Max Nxz
29	RP_Bm10	1	2.14739	222.142	-225.222	-271.857	138.02	-2.32233	118.243		RP_Bm103	Max Mxx
30	RP_Bm10	0	0	1084.18	-209.461	702.1	140.62	-445.202	-0.705403		RP_Bm103	Max Mxy
31	RP_Bm10	1	2.14739	-11.3334	-194.737	-314.03	181.927	25.04	52.6684		RP_Bm103	Max Mxz
32	RP_Bm10	0	0	674.223	-150.049	792.255	119.323	-546.768	-41.2227		RP_Bm103	Min Nxx
33	RP_Bm10	1	2.14739	-265.225	-192.698	-273.542	201.624	51.2093	-20.645		RP_Bm103	Min Nxy
34	RP_Bm10	0	0	-553.141	-75.9508	839.239	93.7811	-583.022	-60.2077		RP_Bm103	Min Nxz
35	RP_Bm10	1	2.14739	-325.13	171.064	-246.844	218.314	79.9909	-94.6941		RP_Bm103	Min Mxx
36	RP_Bm10	0	0	-1901.76	25.4742	785.907	67.7753	-519.314	-51.0528		RP_Bm103	Min Mxy
37	RP_Bm10	1	2.14739	-249.118	600.454	-185.018	209.119	97.3214	-143.794		RP_Bm103	Min Mxz
38	RP_Bm10	0	0	-2874.83	118.494	679.05	51.4715	-403.908	-23.1999
39	RP_Bm10	1	2.14739	-63.9375	934.351	-125.2	185.244	99.9716	-151.381
40	RP_Bm10	0	0	-3678.96	150.71	546.068	50.3216	-247.923	23.9137
41	RP_Bm10	1	2.14739	282.111	1325.15	-116.268	159.691	89.8917	-118.611
42	RP_Bm10	0	0	-4107.94	116.845	413.913	63.463	-86.8242	78.8625
43	RP_Bm10	1	2.14739	685.525	1664.96	-150.93	136.26	69.2678	-56.1412
44	RP_Bm10	0	0	-3426.96	58.2307	308.116	85.4054	19.1858	118.842
45	RP_Bm10	1	2.14739	8.92E+02	1.54E+03	-1.68E+02	1.09E+02	3.87E+01	2.23E+01
46	RP_Bm10	0	0	-2529.68	-34.499	280.571	111.174	53.8998	135.271
47	RP_Bm10	1	2.14739	996.293	1339	-229.887	103.809	15.8244	87.1615
48	RP_Bm10	0	0	-666.559	-95.6609	308.535	132.645	-12.6949	120.549
49	RP_Bm10	1	2.14739	782.731	625.033	-225.704	96.0939	-6.33297	136.511
50	RP_Bm10	0	0	761.599	-141.892	385.969	142.956	-134.538	85.4997
51	RP_Bm10	1	2.14739	467.154	23.1408	-195.647	100.427	-13.8794	142.878
52	RP_Bm10	0	0	1275.83	-187.909	527.021	146.177	-285.295	43.8343
53	RP_Bm10	1	2.14739	213.994	-211.61	-234.698	132.862	-2.03063	113.228
54	RP_Bm10	0	0	1041.62	-196.756	692.027	137.743	-449.966	-0.858227
55	RP_Bm10	1	2.14739	-10.1989	-192.764	-273.579	174.989	23.8436	51.555
56	RP_Bm10	0	0	626.438	-143.83	774.557	117.727	-539.402	-40.5196
57	RP_Bm10	1	2.14739	-244.347	-175.634	-239.299	194.687	49.2614	-18.3672
58	RP_Bm10	0	0	-534.575	-73.6755	819.163	93.5182	-575.961	-57.5607
59	RP_Bm10	1	2.14739	-298.745	169.435	-210.977	209.66	76.0258	-87.756
60	RP_Bm10	0	0	-1839.93	20.8698	762.816	68.8765	-508.469	-47.7618
61	RP_Bm10	1	2.14739	-219.128	591.027	-151.954	200.069	92.1366	-133.967
62	RP_Bm10	0	0	-2810.51	106.659	656.394	53.4752	-391.429	-20.0798
63	RP_Bm10	1	2.14739	-32.8272	932.104	-97.1656	177.173	94.6123	-141.288
64	RP_Bm10	0	0	-3573.58	138.01	526.415	52.2678	-240.283	25.7406
65	RP_Bm10	1	2.14739	295.128	1302.3	-86.1563	151.689	84.544	-109.967
66	RP_Bm10	0	0	-4107.53	100.184	400.516	64.8752	-80.9412	79.3191
67	RP_Bm10	1	2.14739	702.519	1687.31	-128.601	131.64	66.0773	-52.2624
68	RP_Bm10	0	0	-3394.41	50.1576	297.111	85.3038	18.4153	117.98
69	RP_Bm10	1	2.14739	882.789	1535.98	-136.761	102.86	36.0058	22.8523
70	RP_Bm10	0	0	-2559.96	-38.2861	275.003	109.752	48.5762	132.899
71	RP_Bm10	1	2.14739	982.626	1348.99	-199.342	99.7414	14.9998	83.543
72	RP_Bm10	0	0	392.684	-26.039	230.332	125.849	4.62976	117.63
73	RP_Bm10	1	2.14739	535.033	66.5711	-79.1331	54.1882	-21.6308	145.655
74	RP_Bm10	0	0	655.919	-195.52	1367.47	347.156	-601.596	77.8227
75	RP_Bm10	1	2.14739	594.651	141.023	-464.502	391.461	64.7178	166.335
76	RP_Bm10	0	0	1272.8	-243.508	1510.14	350.191	-756.488	32.8841
77	RP_Bm10	1	2.14739	298.492	-144.969	-498.96	423.464	76.5129	133.456
78	RP_Bm10	0	0	993.032	-248.172	1676.42	339.411	-920.069	-16.5231
79	RP_Bm10	1	2.14739	40.2367	-125.371	-535.169	467.111	105.238	62.5954
80	RP_Bm10	0	0	524.12	-185.743	1777.49	316.872	-1033.8	-58.0322
81	RP_Bm10	1	2.14739	-224.823	-107.522	-494.979	488.873	133.18	-15.8124
82	RP_Bm10	0	0	-643.354	-98.1038	1819.78	289.386	-1068.47	-79.6343
83	RP_Bm10	1	2.14739	-315.447	208.246	-456.431	503.331	162.515	-92.8591
84	RP_Bm10	0	0	-2175.56	0.933125	1778.84	263.263	-1010.09	-69.7296
85	RP_Bm10	1	2.14739	-205.53	721.229	-411.27	499.754	182.626	-145.006
86	RP_Bm10	0	0	-3372.49	86.5755	1678.44	246.977	-892.791	-39.8657
87	RP_Bm10	1	2.14739	28.8713	1164.41	-367.843	480.584	187.625	-154.514
88	RP_Bm10	0	0	-4135.36	123.969	1540.79	245.419	-734.482	7.43612
89	RP_Bm10	1	2.14739	371.359	1532.7	-352.604	452.957	176.865	-120.266
90	RP_Bm10	0	0	-4279.02	104.972	1388.79	257.921	-565.506	61.2144
91	RP_Bm10	1	2.14739	727.365	1732.07	-358.05	420.226	152.274	-52.2029
92	RP_Bm10	0	0	-4009.74	22.0153	1294.22	282.19	-445.914	103.574
93	RP_Bm10	1	2.14739	1037.5	1826.81	-423.402	404.978	126.379	24.4551
94	RP_Bm10	0	0	-2688.82	-56.6693	1250.88	308.613	-417.677	122.171
95	RP_Bm10	1	2.14739	1081.06	1427.34	-446.786	387.462	96.2947	100.143
96	RP_Bm10	0	0	-807.296	-128.722	1279.87	332.013	-483.746	108.704
97	RP_Bm10	1	2.14739	879.728	722.382	-449.767	380.598	72.9999	152.78
98	RP_Bm10	0	0	797.048	-149.335	396.158	145.872	-133.24	88.4811
99	RP_Bm103	0	0	-88.7932	-251.286	-1881.01	-224.545	-1167.62	280.179
100	RP_Bm103	1	0.665	-88.7932	-506.982	-1133.21	-224.545	-165.607	28.0123
101	RP_Bm103	0	0	26.4276	-336.31	-1844.55	-197.293	-1130.37	317.322
102	RP_Bm103	1	0.665	26.4276	-556.684	-1096.75	-197.293	-152.593	20.3647
103	RP_Bm103	0	0	-272.787	318.134	-1571.06	43.7993	-862.263	147.933
104	RP_Bm103	1	0.665	-272.787	190.778	-823.26	43.7993	-66.3632	317.125
105	RP_Bm103	0	0	223.987	-616.771	-1783.74	-149.067	-1066.08	382.145
106	RP_Bm103	1	0.665	223.987	-616.771	-1035.94	-149.067	-128.745	-28.0073
107	RP_Bm103	0	0	243.765	-812.547	-1784.41	-150.673	-1065.87	426.697
108	RP_Bm103	1	0.665	243.765	-668.583	-1036.6	-150.673	-128.095	-65.7545
109	RP_Bm103	0	0	200.265	-997.843	-1807.97	-170.181	-1088.53	480.585
110	RP_Bm103	1	0.665	200.265	-752.302	-1060.17	-170.181	-135.084	-101.297
111	RP_Bm103	0	0	91.0047	-1110.65	-1833.38	-188.048	-1114.56	533.811
112	RP_Bm103	1	0.665	91.0047	-823.545	-1085.57	-188.048	-144.225	-109.26
113	RP_Bm103	0	0	-40.8909	-1070.94	-1867.68	-214.211	-1149.25	525.494
114	RP_Bm103	1	0.665	-40.8909	-817.059	-1119.87	-214.211	-156.104	-102.222
115	RP_Bm103	0	0	-173.197	-904.654	-1907.38	-244.798	-1192.09	478.99
116	RP_Bm103	1	0.665	-173.197	-755.19	-1159.58	-244.798	-172.534	-72.883
117	RP_Bm103	0	0	-249.894	-683.745	-1932.98	-263.978	-1218.76	414.602
118	RP_Bm103	1	0.665	-249.894	-683.745	-1185.18	-263.978	-182.191	-40.088
119	RP_Bm103	0	0	-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307
120	RP_Bm103	1	0.665	-252.518	-610.872	-1192.25	-268.861	-184.649	-10.7081
121	RP_Bm103	0	0	-194.293	-287.279	-1921.17	-253.984	-1207.09	290.732
122	RP_Bm103	1	0.665	-194.293	-539.013	-1173.37	-253.984	-178.365	15.9487
123	RP_Bm103	0	0	-85.5642	-266.185	-1888.38	-229.738	-1174.51	296.083
124	RP_Bm103	1	0.665	-85.5642	-549.436	-1140.58	-229.738	-167.594	24.8418
125	RP_Bm103	0	0	38.2749	-305.814	-1852.63	-202.084	-1138.69	305.408
126	RP_Bm103	1	0.665	38.2749	-550.641	-1104.83	-202.084	-155.549	20.5962
127	RP_Bm103	0	0	153.068	-442.545	-1810.06	-168.803	-1093.47	340.945
128	RP_Bm103	1	0.665	153.068	-584.171	-1062.26	-168.803	-138.636	-0.461399
129	RP_Bm103	0	0	195.768	-615.651	-1775.03	-143.588	-1056.78	388.729
130	RP_Bm103	1	0.665	195.768	-615.651	-1027.22	-143.588	-125.243	-20.6789
131	RP_Bm103	0	0	221.429	-809.537	-1779.09	-147.636	-1059.56	433.064
132	RP_Bm103	1	0.665	221.429	-676.142	-1031.28	-147.636	-125.32	-60.9025
133	RP_Bm103	0	0	189.27	-984.88	-1804.82	-168.484	-1084.21	479.581
134	RP_Bm103	1	0.665	189.27	-754.277	-1057.02	-168.484	-132.858	-98.6503
135	RP_Bm103	0	0	86.7061	-1088.72	-1827.58	-184.484	-1107.22	528.736
136	RP_Bm103	1	0.665	86.7061	-820.899	-1079.77	-184.484	-140.74	-106.167
137	RP_Bm103	0	0	-34.5863	-1053.67	-1860.77	-210.054	-1140.72	520.368
138	RP_Bm103	1	0.665	-34.5863	-815.949	-1112.97	-210.054	-152.165	-101.241
139	RP_Bm103	0	0	-165.953	-891.82	-1894.79	-236.08	-1178.07	477.097
140	RP_Bm103	1	0.665	-165.953	-750.971	-1146.99	-236.08	-166.894	-69.1081
141	RP_Bm103	0	0	-238.978	-684.551	-1920.98	-255.534	-1205.72	417.108
142	RP_Bm103	1	0.665	-238.978	-684.551	-1173.18	-255.534	-177.127	-38.1183
143	RP_Bm103	0	0	-246.785	-472.858	-1923.37	-257.041	-1208.51	354.838
144	RP_Bm103	1	0.665	-246.785	-612.422	-1175.57	-257.041	-178.324	-6.04051
145	RP_Bm103	0	0	-187.957	-311.672	-1908.43	-245.39	-1193.81	302.351
146	RP_Bm103	1	0.665	-187.957	-547.394	-1160.63	-245.39	-173.561	16.6725
147	RP_Bm103	0	0	-86.8761	-290.347	-1878.44	-222.905	-1164.36	306.359
148	RP_Bm103	1	0.665	-86.8761	-553.797	-1130.64	-222.905	-164.046	25.6379
149	RP_Bm103	0	0	29.1411	-323.671	-1845.01	-197.283	-1130.62	312.107
150	RP_Bm103	1	0.665	29.1411	-551.38	-1097.21	-197.283	-152.547	21.1152
Test

 

[elgre]

Just to clarify a bit better, I included some formula. I know it is a bit complicated and I am certainly open to any suggestions, regarding presentation/organisation of the data, if it makes it better and easier.

Thank you very much again for you help!

Test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Name	Position	Length [m]	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]		Name	Load	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]
2	RP_Bm1	0	0	304.925	-844.201	-4012.25	-78.8421	304.925	328.703		RP_Bm1	Max Nxx	2234.210	-1329.07	-977.517	18.3758	-546.222	449.834		Find the 2514.330 in D:D, which is max value of Nxx for RP_Bm1 and write the rest of the data, highlighted in yellow. For instance for this row, it is on row210
3	RP_Bm1	1	0.725	415.847	-579.474	-3171.93	-78.8421	393.444	-187.331		RP_Bm1	Max Nxy	1674.620	-133.639	-3244.800	-97.997	-1766.250	275.349		Find the -72.853 in E:E, which is max value of Nxy for RP_Bm1 and write the rest of the data, highlighted in yellow. For instance for this row, it is on row156
4	RP_Bm1	0	0	304.925	-749.923	-4004.62	-78.915	-2205.39	310.541		RP_Bm1	Max Nxz			-3072.620					Do this for RP_Bm10, RP_Bm103, and so on, continue until data finishes in column A:A
5	RP_Bm1	1	0.725	304.925	-513.525	-3164.3	-78.915	392.65	-147.416		RP_Bm1	Max Mxx				-78.842
6	RP_Bm1	0	0	491.227	-579.67	-3980.92	-85.9569	-2187.9	303.333		RP_Bm1	Max Mxy					398.894
7	RP_Bm1	1	0.725	491.227	-440.064	-3140.59	-85.9569	392.957	-66.2948		RP_Bm1	Max Mxz						359.884
8	RP_Bm1	0	0	873.673	-380.372	-3954.64	-94.5345	-2167.93	294.966		RP_Bm1	Min Nxx	304.925
9	RP_Bm1	1	0.725	873.673	-380.372	-3114.31	-94.5345	393.878	19.196		RP_Bm1	Min Nxy		-844.201
10	RP_Bm1	0	0	1345.86	-212.968	-3931.27	-103.778	-2149.46	292.69		RP_Bm1	Min Nxz			-4012.250
11	RP_Bm1	1	0.725	1345.86	-351.575	-3090.95	-103.778	395.405	88.0184		RP_Bm1	Min Mxx				-114.041
12	RP_Bm1	0	0	1801.8	-133.639	-3916.45	-111.022	-2137.07	304.415		RP_Bm1	Min Mxy					-2205.390
13	RP_Bm1	1	0.725	1801.8	-370.254	-3076.13	-111.022	397.054	121.711		RP_Bm1	Min Mxz						-187.331
14	RP_Bm1	0	0	2129.11	-160.057	-3912.95	-114.041	-2133.4	325.863		RP_Bm10	Max Nxx
15	RP_Bm1	1	0.725	2129.11	-422.037	-3072.62	-114.041	398.181	114.806		RP_Bm10	Max Nxy
16	RP_Bm1	0	0	2234.21	-281.519	-3920.57	-112.989	-2138.22	348.731		RP_Bm10	Max Nxz
17	RP_Bm1	1	0.725	2234.21	-507.319	-3080.25	-112.989	398.894	62.7361		RP_Bm10	Max Mxx
18	RP_Bm1	0	0	2042.26	-469.123	-3942.31	-106.102	-2154.1	357.831		RP_Bm10	Max Mxy
19	RP_Bm1	1	0.725	2042.26	-599.863	-3101.99	-106.102	398.776	-29.7		RP_Bm10	Max Mxz
20	RP_Bm1	0	0	1589.84	-651.413	-3967.03	-99.606	-2172.49	359.884		RP_Bm10	Min Nxx
21	RP_Bm1	1	0.725	1589.84	-651.413	-3126.71	-99.606	398.301	-112.391		RP_Bm10	Min Nxy
22	RP_Bm1	0	0	1126.72	-766.254	-3990.02	-92.5375	-2190.49	354.177		RP_Bm10	Min Nxz
23	RP_Bm10	1	2.14739	1098.89	1455.37	-451.537	388.169	96.467	100.971		RP_Bm10	Min Mxx
24	RP_Bm10	0	0	-753.268	-127.788	1275.32	332.454	-480.992	109.534		RP_Bm10	Min Mxy
25	RP_Bm10	1	2.14739	879.373	700.826	-446.277	378.764	71.7518	155.566		RP_Bm10	Min Mxz
26	RP_Bm10	0	0	930.687	-145.602	390.093	146.17	-131.74	88.0633		RP_Bm103	Max Nxx
27	RP_Bm10	1	2.14739	464.855	-36.4774	-223.167	102.642	-15.4912	150.549		RP_Bm103	Max Nxy
28	RP_Bm10	0	0	1355.04	-199.505	534.882	149.668	-281.188	46.0798		RP_Bm103	Max Nxz
29	RP_Bm10	1	2.14739	222.142	-225.222	-271.857	138.02	-2.32233	118.243		RP_Bm103	Max Mxx
30	RP_Bm10	0	0	1084.18	-209.461	702.1	140.62	-445.202	-0.705403		RP_Bm103	Max Mxy
31	RP_Bm10	1	2.14739	-11.3334	-194.737	-314.03	181.927	25.04	52.6684		RP_Bm103	Max Mxz
32	RP_Bm10	0	0	674.223	-150.049	792.255	119.323	-546.768	-41.2227		RP_Bm103	Min Nxx
33	RP_Bm10	1	2.14739	-265.225	-192.698	-273.542	201.624	51.2093	-20.645		RP_Bm103	Min Nxy
34	RP_Bm10	0	0	-553.141	-75.9508	839.239	93.7811	-583.022	-60.2077		RP_Bm103	Min Nxz
35	RP_Bm10	1	2.14739	-325.13	171.064	-246.844	218.314	79.9909	-94.6941		RP_Bm103	Min Mxx
36	RP_Bm10	0	0	-1901.76	25.4742	785.907	67.7753	-519.314	-51.0528		RP_Bm103	Min Mxy
37	RP_Bm10	1	2.14739	-249.118	600.454	-185.018	209.119	97.3214	-143.794		RP_Bm103	Min Mxz
38	RP_Bm10	0	0	-2874.83	118.494	679.05	51.4715	-403.908	-23.1999
39	RP_Bm10	1	2.14739	-63.9375	934.351	-125.2	185.244	99.9716	-151.381
40	RP_Bm10	0	0	-3678.96	150.71	546.068	50.3216	-247.923	23.9137
41	RP_Bm10	1	2.14739	282.111	1325.15	-116.268	159.691	89.8917	-118.611
42	RP_Bm10	0	0	-4107.94	116.845	413.913	63.463	-86.8242	78.8625
43	RP_Bm10	1	2.14739	685.525	1664.96	-150.93	136.26	69.2678	-56.1412
44	RP_Bm10	0	0	-3426.96	58.2307	308.116	85.4054	19.1858	118.842
45	RP_Bm10	1	2.14739	8.92E+02	1.54E+03	-1.68E+02	1.09E+02	3.87E+01	2.23E+01
46	RP_Bm10	0	0	-2529.68	-34.499	280.571	111.174	53.8998	135.271
47	RP_Bm10	1	2.14739	996.293	1339	-229.887	103.809	15.8244	87.1615
48	RP_Bm10	0	0	-666.559	-95.6609	308.535	132.645	-12.6949	120.549
49	RP_Bm10	1	2.14739	782.731	625.033	-225.704	96.0939	-6.33297	136.511
50	RP_Bm10	0	0	761.599	-141.892	385.969	142.956	-134.538	85.4997
51	RP_Bm10	1	2.14739	467.154	23.1408	-195.647	100.427	-13.8794	142.878
52	RP_Bm10	0	0	1275.83	-187.909	527.021	146.177	-285.295	43.8343
53	RP_Bm10	1	2.14739	213.994	-211.61	-234.698	132.862	-2.03063	113.228
54	RP_Bm10	0	0	1041.62	-196.756	692.027	137.743	-449.966	-0.858227
55	RP_Bm10	1	2.14739	-10.1989	-192.764	-273.579	174.989	23.8436	51.555
56	RP_Bm10	0	0	626.438	-143.83	774.557	117.727	-539.402	-40.5196
57	RP_Bm10	1	2.14739	-244.347	-175.634	-239.299	194.687	49.2614	-18.3672
58	RP_Bm10	0	0	-534.575	-73.6755	819.163	93.5182	-575.961	-57.5607
59	RP_Bm10	1	2.14739	-298.745	169.435	-210.977	209.66	76.0258	-87.756
60	RP_Bm10	0	0	-1839.93	20.8698	762.816	68.8765	-508.469	-47.7618
61	RP_Bm10	1	2.14739	-219.128	591.027	-151.954	200.069	92.1366	-133.967
62	RP_Bm10	0	0	-2810.51	106.659	656.394	53.4752	-391.429	-20.0798
63	RP_Bm10	1	2.14739	-32.8272	932.104	-97.1656	177.173	94.6123	-141.288
64	RP_Bm10	0	0	-3573.58	138.01	526.415	52.2678	-240.283	25.7406
65	RP_Bm10	1	2.14739	295.128	1302.3	-86.1563	151.689	84.544	-109.967
66	RP_Bm10	0	0	-4107.53	100.184	400.516	64.8752	-80.9412	79.3191
67	RP_Bm10	1	2.14739	702.519	1687.31	-128.601	131.64	66.0773	-52.2624
68	RP_Bm10	0	0	-3394.41	50.1576	297.111	85.3038	18.4153	117.98
69	RP_Bm10	1	2.14739	882.789	1535.98	-136.761	102.86	36.0058	22.8523
70	RP_Bm10	0	0	-2559.96	-38.2861	275.003	109.752	48.5762	132.899
71	RP_Bm10	1	2.14739	982.626	1348.99	-199.342	99.7414	14.9998	83.543
72	RP_Bm10	0	0	392.684	-26.039	230.332	125.849	4.62976	117.63
73	RP_Bm10	1	2.14739	535.033	66.5711	-79.1331	54.1882	-21.6308	145.655
74	RP_Bm10	0	0	655.919	-195.52	1367.47	347.156	-601.596	77.8227
75	RP_Bm10	1	2.14739	594.651	141.023	-464.502	391.461	64.7178	166.335
76	RP_Bm10	0	0	1272.8	-243.508	1510.14	350.191	-756.488	32.8841
77	RP_Bm10	1	2.14739	298.492	-144.969	-498.96	423.464	76.5129	133.456
78	RP_Bm10	0	0	993.032	-248.172	1676.42	339.411	-920.069	-16.5231
79	RP_Bm10	1	2.14739	40.2367	-125.371	-535.169	467.111	105.238	62.5954
80	RP_Bm10	0	0	524.12	-185.743	1777.49	316.872	-1033.8	-58.0322
81	RP_Bm10	1	2.14739	-224.823	-107.522	-494.979	488.873	133.18	-15.8124
82	RP_Bm10	0	0	-643.354	-98.1038	1819.78	289.386	-1068.47	-79.6343
83	RP_Bm10	1	2.14739	-315.447	208.246	-456.431	503.331	162.515	-92.8591
84	RP_Bm10	0	0	-2175.56	0.933125	1778.84	263.263	-1010.09	-69.7296
85	RP_Bm10	1	2.14739	-205.53	721.229	-411.27	499.754	182.626	-145.006
86	RP_Bm10	0	0	-3372.49	86.5755	1678.44	246.977	-892.791	-39.8657
87	RP_Bm10	1	2.14739	28.8713	1164.41	-367.843	480.584	187.625	-154.514
88	RP_Bm10	0	0	-4135.36	123.969	1540.79	245.419	-734.482	7.43612
89	RP_Bm10	1	2.14739	371.359	1532.7	-352.604	452.957	176.865	-120.266
90	RP_Bm10	0	0	-4279.02	104.972	1388.79	257.921	-565.506	61.2144
91	RP_Bm10	1	2.14739	727.365	1732.07	-358.05	420.226	152.274	-52.2029
92	RP_Bm10	0	0	-4009.74	22.0153	1294.22	282.19	-445.914	103.574
93	RP_Bm10	1	2.14739	1037.5	1826.81	-423.402	404.978	126.379	24.4551
94	RP_Bm10	0	0	-2688.82	-56.6693	1250.88	308.613	-417.677	122.171
95	RP_Bm10	1	2.14739	1081.06	1427.34	-446.786	387.462	96.2947	100.143
96	RP_Bm10	0	0	-807.296	-128.722	1279.87	332.013	-483.746	108.704
97	RP_Bm10	1	2.14739	879.728	722.382	-449.767	380.598	72.9999	152.78
98	RP_Bm10	0	0	797.048	-149.335	396.158	145.872	-133.24	88.4811
99	RP_Bm103	0	0	-88.7932	-251.286	-1881.01	-224.545	-1167.62	280.179
100	RP_Bm103	1	0.665	-88.7932	-506.982	-1133.21	-224.545	-165.607	28.0123
101	RP_Bm103	0	0	26.4276	-336.31	-1844.55	-197.293	-1130.37	317.322
102	RP_Bm103	1	0.665	26.4276	-556.684	-1096.75	-197.293	-152.593	20.3647
103	RP_Bm103	0	0	-272.787	318.134	-1571.06	43.7993	-862.263	147.933
104	RP_Bm103	1	0.665	-272.787	190.778	-823.26	43.7993	-66.3632	317.125
105	RP_Bm103	0	0	223.987	-616.771	-1783.74	-149.067	-1066.08	382.145
106	RP_Bm103	1	0.665	223.987	-616.771	-1035.94	-149.067	-128.745	-28.0073
107	RP_Bm103	0	0	243.765	-812.547	-1784.41	-150.673	-1065.87	426.697
108	RP_Bm103	1	0.665	243.765	-668.583	-1036.6	-150.673	-128.095	-65.7545
109	RP_Bm103	0	0	200.265	-997.843	-1807.97	-170.181	-1088.53	480.585
110	RP_Bm103	1	0.665	200.265	-752.302	-1060.17	-170.181	-135.084	-101.297
111	RP_Bm103	0	0	91.0047	-1110.65	-1833.38	-188.048	-1114.56	533.811
112	RP_Bm103	1	0.665	91.0047	-823.545	-1085.57	-188.048	-144.225	-109.26
113	RP_Bm103	0	0	-40.8909	-1070.94	-1867.68	-214.211	-1149.25	525.494
114	RP_Bm103	1	0.665	-40.8909	-817.059	-1119.87	-214.211	-156.104	-102.222
115	RP_Bm103	0	0	-173.197	-904.654	-1907.38	-244.798	-1192.09	478.99
116	RP_Bm103	1	0.665	-173.197	-755.19	-1159.58	-244.798	-172.534	-72.883
117	RP_Bm103	0	0	-249.894	-683.745	-1932.98	-263.978	-1218.76	414.602
118	RP_Bm103	1	0.665	-249.894	-683.745	-1185.18	-263.978	-182.191	-40.088
119	RP_Bm103	0	0	-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307
120	RP_Bm103	1	0.665	-252.518	-610.872	-1192.25	-268.861	-184.649	-10.7081
121	RP_Bm103	0	0	-194.293	-287.279	-1921.17	-253.984	-1207.09	290.732
122	RP_Bm103	1	0.665	-194.293	-539.013	-1173.37	-253.984	-178.365	15.9487
123	RP_Bm103	0	0	-85.5642	-266.185	-1888.38	-229.738	-1174.51	296.083
124	RP_Bm103	1	0.665	-85.5642	-549.436	-1140.58	-229.738	-167.594	24.8418
125	RP_Bm103	0	0	38.2749	-305.814	-1852.63	-202.084	-1138.69	305.408
126	RP_Bm103	1	0.665	38.2749	-550.641	-1104.83	-202.084	-155.549	20.5962
127	RP_Bm103	0	0	153.068	-442.545	-1810.06	-168.803	-1093.47	340.945
128	RP_Bm103	1	0.665	153.068	-584.171	-1062.26	-168.803	-138.636	-0.461399
129	RP_Bm103	0	0	195.768	-615.651	-1775.03	-143.588	-1056.78	388.729
130	RP_Bm103	1	0.665	195.768	-615.651	-1027.22	-143.588	-125.243	-20.6789
131	RP_Bm103	0	0	221.429	-809.537	-1779.09	-147.636	-1059.56	433.064
132	RP_Bm103	1	0.665	221.429	-676.142	-1031.28	-147.636	-125.32	-60.9025
133	RP_Bm103	0	0	189.27	-984.88	-1804.82	-168.484	-1084.21	479.581
134	RP_Bm103	1	0.665	189.27	-754.277	-1057.02	-168.484	-132.858	-98.6503
135	RP_Bm103	0	0	86.7061	-1088.72	-1827.58	-184.484	-1107.22	528.736
136	RP_Bm103	1	0.665	86.7061	-820.899	-1079.77	-184.484	-140.74	-106.167
137	RP_Bm103	0	0	-34.5863	-1053.67	-1860.77	-210.054	-1140.72	520.368
138	RP_Bm103	1	0.665	-34.5863	-815.949	-1112.97	-210.054	-152.165	-101.241
139	RP_Bm103	0	0	-165.953	-891.82	-1894.79	-236.08	-1178.07	477.097
140	RP_Bm103	1	0.665	-165.953	-750.971	-1146.99	-236.08	-166.894	-69.1081
141	RP_Bm103	0	0	-238.978	-684.551	-1920.98	-255.534	-1205.72	417.108
142	RP_Bm103	1	0.665	-238.978	-684.551	-1173.18	-255.534	-177.127	-38.1183
143	RP_Bm103	0	0	-246.785	-472.858	-1923.37	-257.041	-1208.51	354.838
144	RP_Bm103	1	0.665	-246.785	-612.422	-1175.57	-257.041	-178.324	-6.04051
Test

Cell Formulas
Range	Formula
M2	M2	=MAX(D2:D22)
N3	N3	=MAX(E2:E22)
O4	O4	=MAX(F2:F22)
P5	P5	=MAX(G2:G22)
Q6	Q6	=MAX(H2:H22)
R7	R7	=MAX(I2:I22)
M8	M8	=MIN(D2:D22)
N9	N9	=MIN(E2:E22)
O10	O10	=MIN(F2:F22)
P11	P11	=MIN(G2:G22)
Q12	Q12	=MIN(H2:H22)
R13	R13	=MIN(I2:I22)

 

[Peter_SSs]

Glad you have XL2BB going now.
However, you have given us examples where the results came from rows 210 and 156, yet your XL2BB sample does not go that far!
In your sheet, hide rows 20-150 and 160-200 then post your mini-sheet again down to row 210. That way we should be able to see where the results came from without making your post huge.

 

[DanteAmor]

Could you rewrite your example, because rows 210 and 156 don't exist in your minisheet. So that makes it difficult for me to understand.
And another thing, in cells M2 to R7, there are already values and you only want results in M2, N3, O4, P5, Q6 and R7?

 

[elgre]

Hi again,

You are perfectly right to flag up these points, apologies. I missed them unfortunately.

I created a new clean version below, hope it makes more sense.

The blue cells should be depending on the data in both K:K and L:L. For instance,

if K2=RP_BM1 and L2="Max Nxx", it should calculate max (D2:D22) and write it to M2. or if K24=RP_BM10 and L24="Min Mxy", it should calculate min (H23:H98) and write it to , etc.

Yellow cells are depending on blue cells9 like vlookup. For instance,

if M2 is 2234.210, it should find the row where D:D is 2234.21 (would be row16 in this case) then N2, O2, P2, Q2, R2 should be coming from this row, if Q24 is (lets say) -1068.47, it should find the row where H:H is 2234.21 (would be row82 in this case) then M24, N24, O24, P24, R24 should be coming from this row.

Hope it is a lot more clear now, even explaining is a kind of VBA writing exercise for me! :D

Test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Name	Position	Length [m]	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]		Name	Load	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]
2	RP_Bm1	0	0	304.925	-844.201	-4012.25	-78.8421	304.925	328.703		RP_Bm1	Max Nxx	2234.210	-281.519	-3920.57	-112.989	-2138.22	348.731		Find the 2234.210 in D:D, which is max value of Nxx for RP_Bm1 and write the rest of the data, highlighted in yellow. For instance for this row, it is on row16.
3	RP_Bm1	1	0.725	415.847	-579.474	-3171.93	-78.8421	393.444	-187.331		RP_Bm1	Max Nxy	1801.800	-133.639	-3916.450	-111.022	-2137.070	304.415		Find the -133.639 in E:E, which is max value of Nxy for RP_Bm1 and write the rest of the data, highlighted in yellow. For instance for this row, it is on row12.
4	RP_Bm1	0	0	304.925	-749.923	-4004.62	-78.915	-2205.39	310.541		RP_Bm1	Max Nxz			-3072.620
5	RP_Bm1	1	0.725	304.925	-513.525	-3164.3	-78.915	392.65	-147.416		RP_Bm1	Max Mxx				-78.842				Do this for Max Nxz, Max Mxx, Max Mxy, Max Mxz, Min Nxx, Min Nxy, Min Nxz, Min Mxx, Min Mxy, Min Mxz, for RP_Bm1.
6	RP_Bm1	0	0	491.227	-579.67	-3980.92	-85.9569	-2187.9	303.333		RP_Bm1	Max Mxy					398.894
7	RP_Bm1	1	0.725	491.227	-440.064	-3140.59	-85.9569	392.957	-66.2948		RP_Bm1	Max Mxz						359.884
8	RP_Bm1	0	0	873.673	-380.372	-3954.64	-94.5345	-2167.93	294.966		RP_Bm1	Min Nxx	304.925							Do this for RP_Bm10, RP_Bm103, and so on, continue until data finishes in column A:A
9	RP_Bm1	1	0.725	873.673	-380.372	-3114.31	-94.5345	393.878	19.196		RP_Bm1	Min Nxy		-844.201
10	RP_Bm1	0	0	1345.86	-212.968	-3931.27	-103.778	-2149.46	292.69		RP_Bm1	Min Nxz			-4012.250
11	RP_Bm1	1	0.725	1345.86	-351.575	-3090.95	-103.778	395.405	88.0184		RP_Bm1	Min Mxx				-114.041
12	RP_Bm1	0	0	1801.8	-133.639	-3916.45	-111.022	-2137.07	304.415		RP_Bm1	Min Mxy					-2205.390
13	RP_Bm1	1	0.725	1801.8	-370.254	-3076.13	-111.022	397.054	121.711		RP_Bm1	Min Mxz						-187.331
14	RP_Bm1	0	0	2129.11	-160.057	-3912.95	-114.041	-2133.4	325.863		RP_Bm10	Max Nxx
15	RP_Bm1	1	0.725	2129.11	-422.037	-3072.62	-114.041	398.181	114.806		RP_Bm10	Max Nxy
16	RP_Bm1	0	0	2234.21	-281.519	-3920.57	-112.989	-2138.22	348.731		RP_Bm10	Max Nxz
17	RP_Bm1	1	0.725	2234.21	-507.319	-3080.25	-112.989	398.894	62.7361		RP_Bm10	Max Mxx
18	RP_Bm1	0	0	2042.26	-469.123	-3942.31	-106.102	-2154.1	357.831		RP_Bm10	Max Mxy
19	RP_Bm1	1	0.725	2042.26	-599.863	-3101.99	-106.102	398.776	-29.7		RP_Bm10	Max Mxz
20	RP_Bm1	0	0	1589.84	-651.413	-3967.03	-99.606	-2172.49	359.884		RP_Bm10	Min Nxx
21	RP_Bm1	1	0.725	1589.84	-651.413	-3126.71	-99.606	398.301	-112.391		RP_Bm10	Min Nxy
22	RP_Bm1	0	0	1126.72	-766.254	-3990.02	-92.5375	-2190.49	354.177		RP_Bm10	Min Nxz
23	RP_Bm10	1	2.14739	1098.89	1455.37	-451.537	388.169	96.467	100.971		RP_Bm10	Min Mxx
24	RP_Bm10	0	0	-753.268	-127.788	1275.32	332.454	-480.992	109.534		RP_Bm10	Min Mxy
25	RP_Bm10	1	2.14739	879.373	700.826	-446.277	378.764	71.7518	155.566		RP_Bm10	Min Mxz
26	RP_Bm10	0	0	930.687	-145.602	390.093	146.17	-131.74	88.0633		RP_Bm103	Max Nxx
27	RP_Bm10	1	2.14739	464.855	-36.4774	-223.167	102.642	-15.4912	150.549		RP_Bm103	Max Nxy
28	RP_Bm10	0	0	1355.04	-199.505	534.882	149.668	-281.188	46.0798		RP_Bm103	Max Nxz
29	RP_Bm10	1	2.14739	222.142	-225.222	-271.857	138.02	-2.32233	118.243		RP_Bm103	Max Mxx
30	RP_Bm10	0	0	1084.18	-209.461	702.1	140.62	-445.202	-0.705403		RP_Bm103	Max Mxy
31	RP_Bm10	1	2.14739	-11.3334	-194.737	-314.03	181.927	25.04	52.6684		RP_Bm103	Max Mxz
32	RP_Bm10	0	0	674.223	-150.049	792.255	119.323	-546.768	-41.2227		RP_Bm103	Min Nxx
33	RP_Bm10	1	2.14739	-265.225	-192.698	-273.542	201.624	51.2093	-20.645		RP_Bm103	Min Nxy
34	RP_Bm10	0	0	-553.141	-75.9508	839.239	93.7811	-583.022	-60.2077		RP_Bm103	Min Nxz
35	RP_Bm10	1	2.14739	-325.13	171.064	-246.844	218.314	79.9909	-94.6941		RP_Bm103	Min Mxx
36	RP_Bm10	0	0	-1901.76	25.4742	785.907	67.7753	-519.314	-51.0528		RP_Bm103	Min Mxy
37	RP_Bm10	1	2.14739	-249.118	600.454	-185.018	209.119	97.3214	-143.794		RP_Bm103	Min Mxz
38	RP_Bm10	0	0	-2874.83	118.494	679.05	51.4715	-403.908	-23.1999
39	RP_Bm10	1	2.14739	-63.9375	934.351	-125.2	185.244	99.9716	-151.381
40	RP_Bm10	0	0	-3678.96	150.71	546.068	50.3216	-247.923	23.9137
41	RP_Bm10	1	2.14739	282.111	1325.15	-116.268	159.691	89.8917	-118.611
42	RP_Bm10	0	0	-4107.94	116.845	413.913	63.463	-86.8242	78.8625
43	RP_Bm10	1	2.14739	685.525	1664.96	-150.93	136.26	69.2678	-56.1412
44	RP_Bm10	0	0	-3426.96	58.2307	308.116	85.4054	19.1858	118.842
45	RP_Bm10	1	2.14739	8.92E+02	1.54E+03	-1.68E+02	1.09E+02	3.87E+01	2.23E+01
46	RP_Bm10	0	0	-2529.68	-34.499	280.571	111.174	53.8998	135.271
47	RP_Bm10	1	2.14739	996.293	1339	-229.887	103.809	15.8244	87.1615
48	RP_Bm10	0	0	-666.559	-95.6609	308.535	132.645	-12.6949	120.549
49	RP_Bm10	1	2.14739	782.731	625.033	-225.704	96.0939	-6.33297	136.511
50	RP_Bm10	0	0	761.599	-141.892	385.969	142.956	-134.538	85.4997
51	RP_Bm10	1	2.14739	467.154	23.1408	-195.647	100.427	-13.8794	142.878
52	RP_Bm10	0	0	1275.83	-187.909	527.021	146.177	-285.295	43.8343
53	RP_Bm10	1	2.14739	213.994	-211.61	-234.698	132.862	-2.03063	113.228
54	RP_Bm10	0	0	1041.62	-196.756	692.027	137.743	-449.966	-0.858227
55	RP_Bm10	1	2.14739	-10.1989	-192.764	-273.579	174.989	23.8436	51.555
56	RP_Bm10	0	0	626.438	-143.83	774.557	117.727	-539.402	-40.5196
57	RP_Bm10	1	2.14739	-244.347	-175.634	-239.299	194.687	49.2614	-18.3672
58	RP_Bm10	0	0	-534.575	-73.6755	819.163	93.5182	-575.961	-57.5607
59	RP_Bm10	1	2.14739	-298.745	169.435	-210.977	209.66	76.0258	-87.756
60	RP_Bm10	0	0	-1839.93	20.8698	762.816	68.8765	-508.469	-47.7618
61	RP_Bm10	1	2.14739	-219.128	591.027	-151.954	200.069	92.1366	-133.967
62	RP_Bm10	0	0	-2810.51	106.659	656.394	53.4752	-391.429	-20.0798
63	RP_Bm10	1	2.14739	-32.8272	932.104	-97.1656	177.173	94.6123	-141.288
64	RP_Bm10	0	0	-3573.58	138.01	526.415	52.2678	-240.283	25.7406
65	RP_Bm10	1	2.14739	295.128	1302.3	-86.1563	151.689	84.544	-109.967
66	RP_Bm10	0	0	-4107.53	100.184	400.516	64.8752	-80.9412	79.3191
67	RP_Bm10	1	2.14739	702.519	1687.31	-128.601	131.64	66.0773	-52.2624
68	RP_Bm10	0	0	-3394.41	50.1576	297.111	85.3038	18.4153	117.98
69	RP_Bm10	1	2.14739	882.789	1535.98	-136.761	102.86	36.0058	22.8523
70	RP_Bm10	0	0	-2559.96	-38.2861	275.003	109.752	48.5762	132.899
71	RP_Bm10	1	2.14739	982.626	1348.99	-199.342	99.7414	14.9998	83.543
72	RP_Bm10	0	0	392.684	-26.039	230.332	125.849	4.62976	117.63
73	RP_Bm10	1	2.14739	535.033	66.5711	-79.1331	54.1882	-21.6308	145.655
74	RP_Bm10	0	0	655.919	-195.52	1367.47	347.156	-601.596	77.8227
75	RP_Bm10	1	2.14739	594.651	141.023	-464.502	391.461	64.7178	166.335
76	RP_Bm10	0	0	1272.8	-243.508	1510.14	350.191	-756.488	32.8841
77	RP_Bm10	1	2.14739	298.492	-144.969	-498.96	423.464	76.5129	133.456
78	RP_Bm10	0	0	993.032	-248.172	1676.42	339.411	-920.069	-16.5231
79	RP_Bm10	1	2.14739	40.2367	-125.371	-535.169	467.111	105.238	62.5954
80	RP_Bm10	0	0	524.12	-185.743	1777.49	316.872	-1033.8	-58.0322
81	RP_Bm10	1	2.14739	-224.823	-107.522	-494.979	488.873	133.18	-15.8124
82	RP_Bm10	0	0	-643.354	-98.1038	1819.78	289.386	-1068.47	-79.6343
83	RP_Bm10	1	2.14739	-315.447	208.246	-456.431	503.331	162.515	-92.8591
84	RP_Bm10	0	0	-2175.56	0.933125	1778.84	263.263	-1010.09	-69.7296
85	RP_Bm10	1	2.14739	-205.53	721.229	-411.27	499.754	182.626	-145.006
86	RP_Bm10	0	0	-3372.49	86.5755	1678.44	246.977	-892.791	-39.8657
87	RP_Bm10	1	2.14739	28.8713	1164.41	-367.843	480.584	187.625	-154.514
88	RP_Bm10	0	0	-4135.36	123.969	1540.79	245.419	-734.482	7.43612
89	RP_Bm10	1	2.14739	371.359	1532.7	-352.604	452.957	176.865	-120.266
90	RP_Bm10	0	0	-4279.02	104.972	1388.79	257.921	-565.506	61.2144
91	RP_Bm10	1	2.14739	727.365	1732.07	-358.05	420.226	152.274	-52.2029
92	RP_Bm10	0	0	-4009.74	22.0153	1294.22	282.19	-445.914	103.574
93	RP_Bm10	1	2.14739	1037.5	1826.81	-423.402	404.978	126.379	24.4551
94	RP_Bm10	0	0	-2688.82	-56.6693	1250.88	308.613	-417.677	122.171
95	RP_Bm10	1	2.14739	1081.06	1427.34	-446.786	387.462	96.2947	100.143
96	RP_Bm10	0	0	-807.296	-128.722	1279.87	332.013	-483.746	108.704
97	RP_Bm10	1	2.14739	879.728	722.382	-449.767	380.598	72.9999	152.78
98	RP_Bm10	0	0	797.048	-149.335	396.158	145.872	-133.24	88.4811
99	RP_Bm103	0	0	-88.7932	-251.286	-1881.01	-224.545	-1167.62	280.179
100	RP_Bm103	1	0.665	-88.7932	-506.982	-1133.21	-224.545	-165.607	28.0123
101	RP_Bm103	0	0	26.4276	-336.31	-1844.55	-197.293	-1130.37	317.322
102	RP_Bm103	1	0.665	26.4276	-556.684	-1096.75	-197.293	-152.593	20.3647
103	RP_Bm103	0	0	-272.787	318.134	-1571.06	43.7993	-862.263	147.933
104	RP_Bm103	1	0.665	-272.787	190.778	-823.26	43.7993	-66.3632	317.125
105	RP_Bm103	0	0	223.987	-616.771	-1783.74	-149.067	-1066.08	382.145
106	RP_Bm103	1	0.665	223.987	-616.771	-1035.94	-149.067	-128.745	-28.0073
107	RP_Bm103	0	0	243.765	-812.547	-1784.41	-150.673	-1065.87	426.697
108	RP_Bm103	1	0.665	243.765	-668.583	-1036.6	-150.673	-128.095	-65.7545
109	RP_Bm103	0	0	200.265	-997.843	-1807.97	-170.181	-1088.53	480.585
110	RP_Bm103	1	0.665	200.265	-752.302	-1060.17	-170.181	-135.084	-101.297
111	RP_Bm103	0	0	91.0047	-1110.65	-1833.38	-188.048	-1114.56	533.811
112	RP_Bm103	1	0.665	91.0047	-823.545	-1085.57	-188.048	-144.225	-109.26
113	RP_Bm103	0	0	-40.8909	-1070.94	-1867.68	-214.211	-1149.25	525.494
114	RP_Bm103	1	0.665	-40.8909	-817.059	-1119.87	-214.211	-156.104	-102.222
115	RP_Bm103	0	0	-173.197	-904.654	-1907.38	-244.798	-1192.09	478.99
116	RP_Bm103	1	0.665	-173.197	-755.19	-1159.58	-244.798	-172.534	-72.883
117	RP_Bm103	0	0	-249.894	-683.745	-1932.98	-263.978	-1218.76	414.602
118	RP_Bm103	1	0.665	-249.894	-683.745	-1185.18	-263.978	-182.191	-40.088
119	RP_Bm103	0	0	-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307
120	RP_Bm103	1	0.665	-252.518	-610.872	-1192.25	-268.861	-184.649	-10.7081
121	RP_Bm103	0	0	-194.293	-287.279	-1921.17	-253.984	-1207.09	290.732
122	RP_Bm103	1	0.665	-194.293	-539.013	-1173.37	-253.984	-178.365	15.9487
123	RP_Bm103	0	0	-85.5642	-266.185	-1888.38	-229.738	-1174.51	296.083
124	RP_Bm103	1	0.665	-85.5642	-549.436	-1140.58	-229.738	-167.594	24.8418
125	RP_Bm103	0	0	38.2749	-305.814	-1852.63	-202.084	-1138.69	305.408
126	RP_Bm103	1	0.665	38.2749	-550.641	-1104.83	-202.084	-155.549	20.5962
127	RP_Bm103	0	0	153.068	-442.545	-1810.06	-168.803	-1093.47	340.945
128	RP_Bm103	1	0.665	153.068	-584.171	-1062.26	-168.803	-138.636	-0.461399
129	RP_Bm103	0	0	195.768	-615.651	-1775.03	-143.588	-1056.78	388.729
130	RP_Bm103	1	0.665	195.768	-615.651	-1027.22	-143.588	-125.243	-20.6789
131	RP_Bm103	0	0	221.429	-809.537	-1779.09	-147.636	-1059.56	433.064
132	RP_Bm103	1	0.665	221.429	-676.142	-1031.28	-147.636	-125.32	-60.9025
133	RP_Bm103	0	0	189.27	-984.88	-1804.82	-168.484	-1084.21	479.581
134	RP_Bm103	1	0.665	189.27	-754.277	-1057.02	-168.484	-132.858	-98.6503
135	RP_Bm103	0	0	86.7061	-1088.72	-1827.58	-184.484	-1107.22	528.736
136	RP_Bm103	1	0.665	86.7061	-820.899	-1079.77	-184.484	-140.74	-106.167
Test

Cell Formulas
Range	Formula
M2	M2	=MAX(D2:D22)
N3	N3	=MAX(E2:E22)
O4	O4	=MAX(F2:F22)
P5	P5	=MAX(G2:G22)
Q6	Q6	=MAX(H2:H22)
R7	R7	=MAX(I2:I22)
M8	M8	=MIN(D2:D22)
N9	N9	=MIN(E2:E22)
O10	O10	=MIN(F2:F22)
P11	P11	=MIN(G2:G22)
Q12	Q12	=MIN(H2:H22)
R13	R13	=MIN(I2:I22)

 

[Peter_SSs]

I have used a helper column. See if this is any use.

elgre.xlsm
	A			D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Name			NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]		Name	Load	NXX [N]	NXY [N]	NXZ [N]	MXX [N*m]	MXY [N*m]	MXZ [N*m]	Idx
2	RP_Bm1			304.925	-844.201	-4012.25	-78.8421	304.925	328.703		RP_Bm1	Max Nxx	2234.21	-281.519	-3920.57	-112.989	-2138.22	348.731	16
3	RP_Bm1			415.847	-579.474	-3171.93	-78.8421	393.444	-187.331		RP_Bm1	Max Nxy	1801.8	-133.639	-3916.45	-111.022	-2137.07	304.415	12
4	RP_Bm1			304.925	-749.923	-4004.62	-78.915	-2205.39	310.541		RP_Bm1	Max Nxz	2129.11	-422.037	-3072.62	-114.041	398.181	114.806	15
5	RP_Bm1			304.925	-513.525	-3164.3	-78.915	392.65	-147.416		RP_Bm1	Max Mxx	304.925	-844.201	-4012.25	-78.8421	304.925	328.703	2
6	RP_Bm1			491.227	-579.67	-3980.92	-85.9569	-2187.9	303.333		RP_Bm1	Max Mxy	2234.21	-507.319	-3080.25	-112.989	398.894	62.7361	17
7	RP_Bm1			491.227	-440.064	-3140.59	-85.9569	392.957	-66.2948		RP_Bm1	Max Mxz	1589.84	-651.413	-3967.03	-99.606	-2172.49	359.884	20
8	RP_Bm1			873.673	-380.372	-3954.64	-94.5345	-2167.93	294.966		RP_Bm1	Min Nxx	304.925	-844.201	-4012.25	-78.8421	304.925	328.703	2
9	RP_Bm1			873.673	-380.372	-3114.31	-94.5345	393.878	19.196		RP_Bm1	Min Nxy	304.925	-844.201	-4012.25	-78.8421	304.925	328.703	2
10	RP_Bm1			1345.86	-212.968	-3931.27	-103.778	-2149.46	292.69		RP_Bm1	Min Nxz	304.925	-844.201	-4012.25	-78.8421	304.925	328.703	2
11	RP_Bm1			1345.86	-351.575	-3090.95	-103.778	395.405	88.0184		RP_Bm1	Min Mxx	2129.11	-160.057	-3912.95	-114.041	-2133.4	325.863	14
12	RP_Bm1			1801.8	-133.639	-3916.45	-111.022	-2137.07	304.415		RP_Bm1	Min Mxy	304.925	-749.923	-4004.62	-78.915	-2205.39	310.541	4
13	RP_Bm1			1801.8	-370.254	-3076.13	-111.022	397.054	121.711		RP_Bm1	Min Mxz	415.847	-579.474	-3171.93	-78.8421	393.444	-187.331	3
14	RP_Bm1			2129.11	-160.057	-3912.95	-114.041	-2133.4	325.863		RP_Bm10	Max Nxx	1355.04	-199.505	534.882	149.668	-281.188	46.0798	28
15	RP_Bm1			2129.11	-422.037	-3072.62	-114.041	398.181	114.806		RP_Bm10	Max Nxy	1037.5	1826.81	-423.402	404.978	126.379	24.4551	93
16	RP_Bm1			2234.21	-281.519	-3920.57	-112.989	-2138.22	348.731		RP_Bm10	Max Nxz	-643.354	-98.1038	1819.78	289.386	-1068.47	-79.6343	82
17	RP_Bm1			2234.21	-507.319	-3080.25	-112.989	398.894	62.7361		RP_Bm10	Max Mxx	-315.447	208.246	-456.431	503.331	162.515	-92.8591	83
18	RP_Bm1			2042.26	-469.123	-3942.31	-106.102	-2154.1	357.831		RP_Bm10	Max Mxy	28.8713	1164.41	-367.843	480.584	187.625	-154.514	87
19	RP_Bm1			2042.26	-599.863	-3101.99	-106.102	398.776	-29.7		RP_Bm10	Max Mxz	594.651	141.023	-464.502	391.461	64.7178	166.335	75
20	RP_Bm1			1589.84	-651.413	-3967.03	-99.606	-2172.49	359.884		RP_Bm10	Min Nxx	-4279.02	104.972	1388.79	257.921	-565.506	61.2144	90
21	RP_Bm1			1589.84	-651.413	-3126.71	-99.606	398.301	-112.391		RP_Bm10	Min Nxy	993.032	-248.172	1676.42	339.411	-920.069	-16.5231	78
22	RP_Bm1			1126.72	-766.254	-3990.02	-92.5375	-2190.49	354.177		RP_Bm10	Min Nxz	40.2367	-125.371	-535.169	467.111	105.238	62.5954	79
23	RP_Bm10			1098.89	1455.37	-451.537	388.169	96.467	100.971		RP_Bm10	Min Mxx	-3678.96	150.71	546.068	50.3216	-247.923	23.9137	40
24	RP_Bm10			-753.268	-127.788	1275.32	332.454	-480.992	109.534		RP_Bm10	Min Mxy	-643.354	-98.1038	1819.78	289.386	-1068.47	-79.6343	82
25	RP_Bm10			879.373	700.826	-446.277	378.764	71.7518	155.566		RP_Bm10	Min Mxz	28.8713	1164.41	-367.843	480.584	187.625	-154.514	87
26	RP_Bm10			930.687	-145.602	390.093	146.17	-131.74	88.0633		RP_Bm103	Max Nxx	243.765	-812.547	-1784.41	-150.673	-1065.87	426.697	107
27	RP_Bm10			464.855	-36.4774	-223.167	102.642	-15.4912	150.549		RP_Bm103	Max Nxy	-272.787	318.134	-1571.06	43.7993	-862.263	147.933	103
28	RP_Bm10			1355.04	-199.505	534.882	149.668	-281.188	46.0798		RP_Bm103	Max Nxz	-272.787	190.778	-823.26	43.7993	-66.3632	317.125	104
29	RP_Bm10			222.142	-225.222	-271.857	138.02	-2.32233	118.243		RP_Bm103	Max Mxx	-272.787	318.134	-1571.06	43.7993	-862.263	147.933	103
30	RP_Bm10			1084.18	-209.461	702.1	140.62	-445.202	-0.705403		RP_Bm103	Max Mxy	-272.787	190.778	-823.26	43.7993	-66.3632	317.125	104
31	RP_Bm10			-11.3334	-194.737	-314.03	181.927	25.04	52.6684		RP_Bm103	Max Mxz	91.0047	-1110.65	-1833.38	-188.048	-1114.56	533.811	111
32	RP_Bm10			674.223	-150.049	792.255	119.323	-546.768	-41.2227		RP_Bm103	Min Nxx	-272.787	318.134	-1571.06	43.7993	-862.263	147.933	103
33	RP_Bm10			-265.225	-192.698	-273.542	201.624	51.2093	-20.645		RP_Bm103	Min Nxy	91.0047	-1110.65	-1833.38	-188.048	-1114.56	533.811	111
34	RP_Bm10			-553.141	-75.9508	839.239	93.7811	-583.022	-60.2077		RP_Bm103	Min Nxz	-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307	119
35	RP_Bm10			-325.13	171.064	-246.844	218.314	79.9909	-94.6941		RP_Bm103	Min Mxx	-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307	119
36	RP_Bm10			-1901.76	25.4742	785.907	67.7753	-519.314	-51.0528		RP_Bm103	Min Mxy	-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307	119
37	RP_Bm10			-249.118	600.454	-185.018	209.119	97.3214	-143.794		RP_Bm103	Min Mxz	91.0047	-823.545	-1085.57	-188.048	-144.225	-109.26	112
38	RP_Bm10			-2874.83	118.494	679.05	51.4715	-403.908	-23.1999
39	RP_Bm10			-63.9375	934.351	-125.2	185.244	99.9716	-151.381
40	RP_Bm10			-3678.96	150.71	546.068	50.3216	-247.923	23.9137
41	RP_Bm10			282.111	1325.15	-116.268	159.691	89.8917	-118.611
42	RP_Bm10			-4107.94	116.845	413.913	63.463	-86.8242	78.8625
43	RP_Bm10			685.525	1664.96	-150.93	136.26	69.2678	-56.1412
44	RP_Bm10			-3426.96	58.2307	308.116	85.4054	19.1858	118.842
45	RP_Bm10			891.967	1543.55	-167.844	108.616	38.6867	22.2554
46	RP_Bm10			-2529.68	-34.499	280.571	111.174	53.8998	135.271
47	RP_Bm10			996.293	1339	-229.887	103.809	15.8244	87.1615
48	RP_Bm10			-666.559	-95.6609	308.535	132.645	-12.6949	120.549
49	RP_Bm10			782.731	625.033	-225.704	96.0939	-6.33297	136.511
50	RP_Bm10			761.599	-141.892	385.969	142.956	-134.538	85.4997
51	RP_Bm10			467.154	23.1408	-195.647	100.427	-13.8794	142.878
52	RP_Bm10			1275.83	-187.909	527.021	146.177	-285.295	43.8343
53	RP_Bm10			213.994	-211.61	-234.698	132.862	-2.03063	113.228
54	RP_Bm10			1041.62	-196.756	692.027	137.743	-449.966	-0.858227
55	RP_Bm10			-10.1989	-192.764	-273.579	174.989	23.8436	51.555
56	RP_Bm10			626.438	-143.83	774.557	117.727	-539.402	-40.5196
57	RP_Bm10			-244.347	-175.634	-239.299	194.687	49.2614	-18.3672
58	RP_Bm10			-534.575	-73.6755	819.163	93.5182	-575.961	-57.5607
59	RP_Bm10			-298.745	169.435	-210.977	209.66	76.0258	-87.756
60	RP_Bm10			-1839.93	20.8698	762.816	68.8765	-508.469	-47.7618
61	RP_Bm10			-219.128	591.027	-151.954	200.069	92.1366	-133.967
62	RP_Bm10			-2810.51	106.659	656.394	53.4752	-391.429	-20.0798
63	RP_Bm10			-32.8272	932.104	-97.1656	177.173	94.6123	-141.288
64	RP_Bm10			-3573.58	138.01	526.415	52.2678	-240.283	25.7406
65	RP_Bm10			295.128	1302.3	-86.1563	151.689	84.544	-109.967
66	RP_Bm10			-4107.53	100.184	400.516	64.8752	-80.9412	79.3191
67	RP_Bm10			702.519	1687.31	-128.601	131.64	66.0773	-52.2624
68	RP_Bm10			-3394.41	50.1576	297.111	85.3038	18.4153	117.98
69	RP_Bm10			882.789	1535.98	-136.761	102.86	36.0058	22.8523
70	RP_Bm10			-2559.96	-38.2861	275.003	109.752	48.5762	132.899
71	RP_Bm10			982.626	1348.99	-199.342	99.7414	14.9998	83.543
72	RP_Bm10			392.684	-26.039	230.332	125.849	4.62976	117.63
73	RP_Bm10			535.033	66.5711	-79.1331	54.1882	-21.6308	145.655
74	RP_Bm10			655.919	-195.52	1367.47	347.156	-601.596	77.8227
75	RP_Bm10			594.651	141.023	-464.502	391.461	64.7178	166.335
76	RP_Bm10			1272.8	-243.508	1510.14	350.191	-756.488	32.8841
77	RP_Bm10			298.492	-144.969	-498.96	423.464	76.5129	133.456
78	RP_Bm10			993.032	-248.172	1676.42	339.411	-920.069	-16.5231
79	RP_Bm10			40.2367	-125.371	-535.169	467.111	105.238	62.5954
80	RP_Bm10			524.12	-185.743	1777.49	316.872	-1033.8	-58.0322
81	RP_Bm10			-224.823	-107.522	-494.979	488.873	133.18	-15.8124
82	RP_Bm10			-643.354	-98.1038	1819.78	289.386	-1068.47	-79.6343
83	RP_Bm10			-315.447	208.246	-456.431	503.331	162.515	-92.8591
84	RP_Bm10			-2175.56	0.933125	1778.84	263.263	-1010.09	-69.7296
85	RP_Bm10			-205.53	721.229	-411.27	499.754	182.626	-145.006
86	RP_Bm10			-3372.49	86.5755	1678.44	246.977	-892.791	-39.8657
87	RP_Bm10			28.8713	1164.41	-367.843	480.584	187.625	-154.514
88	RP_Bm10			-4135.36	123.969	1540.79	245.419	-734.482	7.43612
89	RP_Bm10			371.359	1532.7	-352.604	452.957	176.865	-120.266
90	RP_Bm10			-4279.02	104.972	1388.79	257.921	-565.506	61.2144
91	RP_Bm10			727.365	1732.07	-358.05	420.226	152.274	-52.2029
92	RP_Bm10			-4009.74	22.0153	1294.22	282.19	-445.914	103.574
93	RP_Bm10			1037.5	1826.81	-423.402	404.978	126.379	24.4551
94	RP_Bm10			-2688.82	-56.6693	1250.88	308.613	-417.677	122.171
95	RP_Bm10			1081.06	1427.34	-446.786	387.462	96.2947	100.143
96	RP_Bm10			-807.296	-128.722	1279.87	332.013	-483.746	108.704
97	RP_Bm10			879.728	722.382	-449.767	380.598	72.9999	152.78
98	RP_Bm10			797.048	-149.335	396.158	145.872	-133.24	88.4811
99	RP_Bm103			-88.7932	-251.286	-1881.01	-224.545	-1167.62	280.179
100	RP_Bm103			-88.7932	-506.982	-1133.21	-224.545	-165.607	28.0123
101	RP_Bm103			26.4276	-336.31	-1844.55	-197.293	-1130.37	317.322
102	RP_Bm103			26.4276	-556.684	-1096.75	-197.293	-152.593	20.3647
103	RP_Bm103			-272.787	318.134	-1571.06	43.7993	-862.263	147.933
104	RP_Bm103			-272.787	190.778	-823.26	43.7993	-66.3632	317.125
105	RP_Bm103			223.987	-616.771	-1783.74	-149.067	-1066.08	382.145
106	RP_Bm103			223.987	-616.771	-1035.94	-149.067	-128.745	-28.0073
107	RP_Bm103			243.765	-812.547	-1784.41	-150.673	-1065.87	426.697
108	RP_Bm103			243.765	-668.583	-1036.6	-150.673	-128.095	-65.7545
109	RP_Bm103			200.265	-997.843	-1807.97	-170.181	-1088.53	480.585
110	RP_Bm103			200.265	-752.302	-1060.17	-170.181	-135.084	-101.297
111	RP_Bm103			91.0047	-1110.65	-1833.38	-188.048	-1114.56	533.811
112	RP_Bm103			91.0047	-823.545	-1085.57	-188.048	-144.225	-109.26
113	RP_Bm103			-40.8909	-1070.94	-1867.68	-214.211	-1149.25	525.494
114	RP_Bm103			-40.8909	-817.059	-1119.87	-214.211	-156.104	-102.222
115	RP_Bm103			-173.197	-904.654	-1907.38	-244.798	-1192.09	478.99
116	RP_Bm103			-173.197	-755.19	-1159.58	-244.798	-172.534	-72.883
117	RP_Bm103			-249.894	-683.745	-1932.98	-263.978	-1218.76	414.602
118	RP_Bm103			-249.894	-683.745	-1185.18	-263.978	-182.191	-40.088
119	RP_Bm103			-252.518	-462.783	-1940.05	-268.861	-1225.93	346.307
120	RP_Bm103			-252.518	-610.872	-1192.25	-268.861	-184.649	-10.7081
121	RP_Bm103			-194.293	-287.279	-1921.17	-253.984	-1207.09	290.732
122	RP_Bm103			-194.293	-539.013	-1173.37	-253.984	-178.365	15.9487
123	RP_Bm103			-85.5642	-266.185	-1888.38	-229.738	-1174.51	296.083
124	RP_Bm103			-85.5642	-549.436	-1140.58	-229.738	-167.594	24.8418
125	RP_Bm103			38.2749	-305.814	-1852.63	-202.084	-1138.69	305.408
126	RP_Bm103			38.2749	-550.641	-1104.83	-202.084	-155.549	20.5962
127	RP_Bm103			153.068	-442.545	-1810.06	-168.803	-1093.47	340.945
128	RP_Bm103			153.068	-584.171	-1062.26	-168.803	-138.636	-0.461399
129	RP_Bm103			195.768	-615.651	-1775.03	-143.588	-1056.78	388.729
130	RP_Bm103			195.768	-615.651	-1027.22	-143.588	-125.243	-20.6789
131	RP_Bm103			221.429	-809.537	-1779.09	-147.636	-1059.56	433.064
132	RP_Bm103			221.429	-676.142	-1031.28	-147.636	-125.32	-60.9025
133	RP_Bm103			189.27	-984.88	-1804.82	-168.484	-1084.21	479.581
134	RP_Bm103			189.27	-754.277	-1057.02	-168.484	-132.858	-98.6503
135	RP_Bm103			86.7061	-1088.72	-1827.58	-184.484	-1107.22	528.736
136	RP_Bm103			86.7061	-820.899	-1079.77	-184.484	-140.74	-106.167
Sheet1

Cell Formulas
Range	Formula
M2:R37	M2	=INDEX(D:D,$S2)
S2:S37	S2	=AGGREGATE(15,6,ROW(A$2:A$1000)/((A$2:A$1000=$K2)*(INDEX(D$2:I$1000,0,MATCH(RIGHT(L2,3)&"*",D$1:I$1,0))=AGGREGATE(IF(LEFT(L2,3)="Max",14,15),6,INDEX(D$2:I$1000,0,MATCH(RIGHT(L2,3)&"*",D$1:I$1,0))/(A$2:A$1000=$K2),1))),1)

 

[elgre]

Just one word: Brilliant!

Thank you very much for this! It works perfectly!