I have large spreadsheet with one column having alpha-numeric entries:
AZ0011
M0004
R003
AZ01
M01
R1
...and so on
I need to take the column, probably to another sheet, and with a macro, sort it by the alpha part and the numeric part and then see what sequential numbers are missing.
Result:
AZ01
AZ0002
AZ003
AZ0004
Missing AZ05 <-- these could be hi-lited
Missing AZ06
AZ007
M01
Missing M002
Missing M003
M0004
R01
Missing R002
R003
Any help offered would be appreciated!
AZ0011
M0004
R003
AZ01
M01
R1
...and so on
I need to take the column, probably to another sheet, and with a macro, sort it by the alpha part and the numeric part and then see what sequential numbers are missing.
Result:
AZ01
AZ0002
AZ003
AZ0004
Missing AZ05 <-- these could be hi-lited
Missing AZ06
AZ007
M01
Missing M002
Missing M003
M0004
R01
Missing R002
R003
Any help offered would be appreciated!