Hi all, could someone please assist me with the correct code to find the highest alphanumeric number containing specific alpha characters? the format will always be the same: two numbers, three alpha, four numbers - 12ABC1234
first two digits are the year the number is assigned, followed by a 3 character location key, then a sequential number
for example, sheet 2 column d contains a list like
20CDA0002
20ABC0005
20DCD0003
20ABC0006
I need to find the highest value containing the given key, eg. DCD, and suggest the next number - 20DCD0004
Any help would be appreciated.
Bookmarks