Named Range for second to last column

[mst3k4L]

0	0	0.000	0.0000	0	0	0	0.000E+00	0	#DIV/0!
5	150	178.655	56.9168	93.08323	18.61665	178.6549	7.075E-05	0.251772	62.05548854
10	300	246.725	159.0954	140.9046	14.09046	246.7251	1.104E-04	0.295874	46.96819991
15	450	312.591	252.4142	197.5858	13.17239	312.5915	-1.424E-04	0.333035	43.90795545
20	600	369.339	349.3855	250.6145	12.53073	369.3393	1.982E-05	0.362004	41.76908398
25	750	420.745	448.0819	301.9181	12.07672	420.7447	2.650E-05	0.386376	40.25574265
30	900	468.078	548.3628	351.6372	11.72124	468.0781	2.735E-05	0.40753	39.07079844
35	1050	512.237	649.9781	400.0219	11.4292	512.2367	2.574E-05	0.42632	38.09732516
40	1200	553.820	752.7506	447.2494	11.18123	553.8204	2.306E-05	0.443287	37.27077935
45	1350	593.260	856.5409	493.4591	10.96576	593.26	1.995E-05	0.4588	36.55252515
50	1500	630.876	961.2374	538.7626	10.77525	630.8767	-7.176E-04	0.473122	35.91750947
55	1650	666.917	1066.7495	583.2505	10.60455	666.9175	-6.036E-04	0.486449	35.34851267
60	1800	701.577	1173.0026	626.9974	10.44996	701.5773	-4.817E-04	0.498929	34.83318862

<tbody>
</tbody>

I got multiple tables of data of varying widths, but the second to last column is always the desired value. How do I create a named range of the second to last column? I'm sure it involves some cleaver use of "offset(", but I couldn't figure it out. Thanks in advance.

 

[Robert Mika]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	0	0	0	0	0	0	0	0.00E+00	0	890
2	5	150	178.655	56.9168	93.08323	18.61665	178.6549	7.08E-05	0.251772	62.05549
3	10	300	246.725	159.0954	140.9046	14.09046	246.7251	1.10E-04	0.295874	46.9682			4.823498
4	15	450	312.591	252.4142	197.5858	13.17239	312.5915	-1.42E-04	0.333035	43.90796
5	20	600	369.339	349.3855	250.6145	12.53073	369.3393	1.98E-05	0.362004	41.76908
6	25	750	420.745	448.0819	301.9181	12.07672	420.7447	2.65E-05	0.386376	40.25574
7	30	900	468.078	548.3628	351.6372	11.72124	468.0781	2.74E-05	0.40753	39.0708
8	35	1050	512.237	649.9781	400.0219	11.4292	512.2367	2.57E-05	0.42632	38.09733
9	40	1200	553.82	752.7506	447.2494	11.18123	553.8204	2.31E-05	0.443287	37.27078
10	45	1350	593.26	856.5409	493.4591	10.96576	593.26	2.00E-05	0.4588	36.55253
11	50	1500	630.876	961.2374	538.7626	10.77525	630.8767	-7.18E-04	0.473122	35.91751
12	55	1650	666.917	1066.75	583.2505	10.60455	666.9175	-6.04E-04	0.486449	35.34851
13	60	1800	701.577	1173.003	626.9974	10.44996	701.5773	-4.82E-04	0.498929	34.83319
Sheet1

=OFFSET(Sheet1!$A$1,0,COUNTA(Sheet1!$A$1:$P$1)-2,20,1)

 

[mst3k4L]

Thanks! I was able to use that to get something slightly more generic

=OFFSET(sheet1!$A$23,0,COUNTA(sheet1!$A$23:$IV$23)-2,COUNTA(sheet1!$A$23:$A$65536),1)