MAX Function to obtain highest value of numbers with a letter prefix

I'm trying to get the highest value for a column of numbers that start with the prefix T: T1000, T1001, T1002, T1003...to get T1003 as the highest.
I've tried =MAX(A1:A23), but I get a 0 as a result. I have also tried =MAX(LEFT(A1:A23,1)) but I a get #VALUE! result.
What would be the right formula?


Capture.JPG

Try this formula in cell where you want the largest value. Not my original.

Formula:

=LOOKUP(2,1/(COUNTIF(A2:A13,"<"&A2:A13)=0),A2:A13)

Thanks! It worked! I just had to change the symbol from "<" to ">" because it was giving me the smaller value. Thanks again!!

Originally Posted by wyowhite

Try this formula in cell where you want the largest value. Not my original.

Formula:

=LOOKUP(2,1/(COUNTIF(A2:A13,"<"&A2:A13)=0),A2:A13)

Thanks! It worked! I just had to change the symbol from "<" to ">" because it was giving me the smaller value. Thanks again!!

Thanks! That works too! showing the answer without prefix if preferable.