Dear all
I would like to retrieve the highest value from two columns of prefixed numbers.
Sheet1, column A:
P100859
P100123
P100159
P100258
P100397
P100157
Sheet2, column A:
P100752
P100151
P100966
P100227
P100342
P100666
I would love to have a macro that returns the highest value (P100966). The values are always prefixed with the same letter and always have the same length.
Thanks for helping out!
Bookmarks