Sort spilled data by the name of the column and not a number

[CV12]

Hello everyone,

I would like to sort my spilled data by the name of the column (Q - O). Is it somehow possible to change the '1' in the sort formula to the letter Q?
Same principe for the 1 = ascending and -1 descending. Would it be possible to have a dropdown menu with ascending and descending, and link that to either 1 or -1?

Would love to hear if that is possible . Would be a bit easier for the user of my sheet.

=SORT(FILTER(M2:U19,U2:U19<>""),(1),1)

Would like to have the letter Q for example, in the red part of the formula.

Results SBB8.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1			Q	W	E	R	T	Y	U	I	O		Q	W	E	R	T	Y	U	I	O
2			1	1.00	597.65	23.93	790.66	2.00	0.00	2.87	377.76		1	1	597.646	23.929	790.657	2	0	2.86591	377.764
3	Q		2	3.00	-732.74	23.93	780.72	4.00	0.00	2.87	516.60		2	3	-732.741	23.929	780.719	4	0	2.86591	516.597
4			3	5.00	590.72	18.99	1294.88	6.00	0.00	2.10	582.49		3	5	590.723	18.9889	1294.88	6	0	2.09575	582.49
5			4	7.00	-498.28	18.99	1352.59	8.00	0.00	2.10	694.59		4	7	-498.283	18.9889	1352.59	8	0	2.09575	694.591
6			5	9.00	270.05	9.12	1521.79	10.00	0.00	1.47	748.05		5	9	270.054	9.12281	1521.79	10	0	1.47377	748.052
7			6	11.00	-263.78	9.12	1541.59	12.00	0.00	1.47	783.21		6	11	-263.778	9.12281	1541.59	12	0	1.47377	783.21
8			7	13.00	184.41	6.14	1688.71	14.00	0.00	1.08	817.45		7	13	184.407	6.13769	1688.71	14	0	1.0778	817.454
9			8	15.00	-174.77	6.14	1705.57	16.00	0.00	1.08	859.44		8	15	-174.769	6.13769	1705.57	16	0	1.0778	859.44
10			9	17.00	34.79	0.54	1787.16	18.00	0.00	0.01	871.71		9	17	34.7863	0.54077	1787.16	18	0	0.01237	871.711
11			10	19.00	4.47	0.54	1788.29	20.00	0.00	0.01	875.07		10	19	4.47031	0.54077	1788.29	20	0	0.01237	875.066
12			11	21.00	-157.58	-5.72	1726.75	22.00	0.00	-1.09	867.40		11	21	-157.58	-5.72015	1726.75	22	0	-1.09106	867.399
13			12	23.00	180.43	-5.72	1713.88	24.00	0.00	-1.09	824.54		12	23	180.434	-5.72015	1713.88	24	0	-1.09106	824.544
14			13	25.00	-276.02	-9.52	1553.58	26.00	0.00	-1.50	792.38		13	25	-276.024	-9.52177	1553.58	26	0	-1.49798	792.375
15			14	27.00	282.45	-9.52	1533.54	28.00	0.00	-1.50	751.20		14	27	282.452	-9.52177	1533.54	28	0	-1.49798	751.203
16			15	29.00	-509.98	-19.50	1356.76	30.00	0.00	-2.04	697.35		15	29	-509.983	-19.5049	1356.76	30	0	-2.04185	697.352
17			16	31.00	602.67	-19.50	1300.19	32.00	0.00	-2.04	586.40		16	31	602.67	-19.5049	1300.19	32	0	-2.04185	586.405
18			17	33.00	-739.33	-24.16	781.67	34.00	0.00	-2.85	516.58		17	33	-739.327	-24.1646	781.675	34	0	-2.84872	516.58
19			18	35.00	604.84	-24.16	790.62	36.00	0.00	-2.85	378.57		18	35	604.842	-24.1646	790.623	36	0	-2.84872	378.574
Sandbox2

Cell Formulas
Range	Formula
C2:K19	C2	=SORT(FILTER(M2:U19,U2:U19<>""),(1),1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
F12	List	=$I$3#

 

[Peter_SSs]

Try this

22 01 31.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1			Q	W	E	R	T	Y	U	I	O		Q	W	E	R	T	Y	U	I	O
2	Sort By		18	35.00	604.84	-24.16	790.62	36.00	0.00	-2.85	378.57		1	1.00	597.65	23.93	790.66	2.00	0.00	2.87	377.76
3	Q		17	33.00	-739.33	-24.16	781.67	34.00	0.00	-2.85	516.58		2	3.00	-732.74	23.93	780.72	4.00	0.00	2.87	516.60
4			16	31.00	602.67	-19.50	1300.19	32.00	0.00	-2.04	586.40		3	5.00	590.72	18.99	1294.88	6.00	0.00	2.10	582.49
5	Asc/Desc		15	29.00	-509.98	-19.50	1356.76	30.00	0.00	-2.04	697.35		4	7.00	-498.28	18.99	1352.59	8.00	0.00	2.10	694.59
6	Descending		14	27.00	282.45	-9.52	1533.54	28.00	0.00	-1.50	751.20		5	9.00	270.05	9.12	1521.79	10.00	0.00	1.47	748.05
7			13	25.00	-276.02	-9.52	1553.58	26.00	0.00	-1.50	792.38		6	11.00	-263.78	9.12	1541.59	12.00	0.00	1.47	783.21
8			12	23.00	180.43	-5.72	1713.88	24.00	0.00	-1.09	824.54		7	13.00	184.41	6.14	1688.71	14.00	0.00	1.08	817.45
9			11	21.00	-157.58	-5.72	1726.75	22.00	0.00	-1.09	867.40		8	15.00	-174.77	6.14	1705.57	16.00	0.00	1.08	859.44
10			10	19.00	4.47	0.54	1788.29	20.00	0.00	0.01	875.07		9	17.00	34.79	0.54	1787.16	18.00	0.00	0.01	871.71
11			9	17.00	34.79	0.54	1787.16	18.00	0.00	0.01	871.71		10	19.00	4.47	0.54	1788.29	20.00	0.00	0.01	875.07
12			8	15.00	-174.77	6.14	1705.57	16.00	0.00	1.08	859.44		11	21.00	-157.58	-5.72	1726.75	22.00	0.00	-1.09	867.40
13			7	13.00	184.41	6.14	1688.71	14.00	0.00	1.08	817.45		12	23.00	180.43	-5.72	1713.88	24.00	0.00	-1.09	824.54
14			6	11.00	-263.78	9.12	1541.59	12.00	0.00	1.47	783.21		13	25.00	-276.02	-9.52	1553.58	26.00	0.00	-1.50	792.38
15			5	9.00	270.05	9.12	1521.79	10.00	0.00	1.47	748.05		14	27.00	282.45	-9.52	1533.54	28.00	0.00	-1.50	751.20
16			4	7.00	-498.28	18.99	1352.59	8.00	0.00	2.10	694.59		15	29.00	-509.98	-19.50	1356.76	30.00	0.00	-2.04	697.35
17			3	5.00	590.72	18.99	1294.88	6.00	0.00	2.10	582.49		16	31.00	602.67	-19.50	1300.19	32.00	0.00	-2.04	586.40
18			2	3.00	-732.74	23.93	780.72	4.00	0.00	2.87	516.60		17	33.00	-739.33	-24.16	781.67	34.00	0.00	-2.85	516.58
19			1	1.00	597.65	23.93	790.66	2.00	0.00	2.87	377.76		18	35.00	604.84	-24.16	790.62	36.00	0.00	-2.85	378.57
20
Sort Filter

Cell Formulas
Range	Formula
C2:K19	C2	=SORT(FILTER(M2:U19,U2:U19<>""),MATCH(A3,M1:U1,0),IF(A6="Ascending",1,-1))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
A6	List	Ascending, Descending

 

[CV12]

Very nice, thanks once again, Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.