Pick highest numerical version in a List

[indy1982]

Hello,

I have the data below in Column A, each reference is a different cell going down in the column A1,A2,A3,A4 etc.

I would like a formula that picks out the bold references in the list below, so the highest number in the sequence using the last 2 or 3 numbers in the reference example below (851055TSAPPLE44). The number of characters in the cell could change, but I always want to pick out the 'highest version' by looking at the last 2 or 3 numerical digits (could be more) at the end.

Any help would be much appreciated. I have tried index and match formula to no avail.Thank you.


851055TSAPPLE35
851055TSAPPLE42
851055TSAPPLE43
851055TSAPPLE44
909011TSAPPLE40
909011TSAPPLE48
909011TSAPPLE49
1003983TSAPPLE153
1003983TSAPPLE167
1003983TSAPPLE168
1003983TSAPPLE170

 

[indy1982]

No they can be any value, any letter and any length of characters.

 

[indy1982]

Hello

Is anybody able to help with this request please?

Thank you