Formula help required - lookup and return the max alphanumeric value

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

sorry what is the order of revisions?
a ,a1,a2,b,b1,b2,b3....,zz,zz1,zz2, 1, 2, 3 so t2 is later than c5 or what? and any number on its own later than any letter number combination?

We find subcontractor's use either single digit A, B,, 1, 2, 3 or double digits T1, T2, T3, C1, C2, C3. but not a combination. If the formula could work with either would be my ideal.

In terms of heirarchy for the double digits, let's say the first letter is of primary importance so C1 trumps A1, A5, A9 etc and of course C2 trumps C1.

would there be cases of a,b,1,2 oh is see lsat example a,d,c, 1,2,3
would they always be in order from left to right and you just want the last one?
given all that what are the results expected in b29:b35

Unfortunately it can't just grab the right-most cell with a value, it has to evaluate all cells in the range and determine the highest value. The current formula is working exactly this way but only for single digits.
On the example spreadsheet, I expect the range B29:B35 to show T2, T1, T1, T1, T1, T1, 3 from top to bottom. In the example case I'm looking for T1 to trump C1, C2, C3 & C4. In future I may have a case where I want C1 to trump T1 but in the first instance I need a formula that effectively evaluates the two digits.

=INDEX(J29:T29,IF(COUNT(J29:T29),MATCH(MAX(J29:T29),J29:T29,0),MATCH(MAX(IFERROR(CODE(LEFT(J29:T29))+TEXT(MID(J29:T29,2,3),"000")/100,0)),IFERROR(CODE(LEFT(J29:T29))+TEXT(MID(J29:T29,2,3),"000")/100,0),0)))
array entered

no its because you have 2003 blast

=index(j29:t29,if(count(j29:t29),match(max(j29:t29),j29:t29,0),match(max(if(iserror(code(left(j29:t29))+text(mid(j29:t29,2,3),"000")/100),0,code(left(j29:t29))+text(mid(j29:t29,2,3),"000")/100)),if(iserror(code(left(j29:t29))+text(mid(j29:t29,2,3),"000")/100),0,code(left(j29:t29))+text(mid(j29:t29,2,3),"000")/100),0)))