Good Day All,

I have a problem where I have numbers that have multiple instruction reference numbers assigned to them. I need to know which is the most current. For example the reference numbers look like this A0001_022103139B and the fifth digit increases by one when a new one is created. I can not figure out how to search to find the newest one (highest number) I have attached a example on the data and the ones highlighted in yellow is what I am looking for by using the number in column a as the search key.

Example.xlsx


Thank You for any advise or help,

David