How to sort() value with alpha numeric

[mart_mrexcel]

I have values in a column where i want to sort (using SORT function) from highest to lowest (or vice versa), but the data has letters.

T3
T12
T7
T14
T13
T15
T5
T4
T2
T0
T16

 

[Georgiboy]

Is it always the letter T?

 

[mart_mrexcel]

Is it always the letter T?

Yes

 

[Georgiboy]

Here is an option to try:

Book1
	A	B
2	T3	T0
3	T12	T2
4	T7	T3
5	T14	T4
6	T13	T5
7	T15	T7
8	T5	T12
9	T4	T13
10	T2	T14
11	T0	T15
12	T16	T16
Sheet1

Cell Formulas
Range	Formula
B2:B12	B2	=LET(r,A2:A12,d,--SUBSTITUTE(r,"T",""),SORTBY(r,d,1))
Dynamic array formulas.

 

[mart_mrexcel]

Here is an option to try:

Book1
	A	B
2	T3	T0
3	T12	T2
4	T7	T3
5	T14	T4
6	T13	T5
7	T15	T7
8	T5	T12
9	T4	T13
10	T2	T14
11	T0	T15
12	T16	T16
Sheet1

Cell Formulas
Range	Formula
B2:B12	B2	=LET(r,A2:A12,d,--SUBSTITUTE(A2:A12,"T",""),SORTBY(r,d,1))
Dynamic array formulas.

That works perfect ... thank you

 

[Georgiboy]

You are welcome, thanks for the feedback.

I have made the formula slightly shorter in post 4.