Hello,

I'm trying to find a formula that will return the latest revision from a range A1:A7. This range could include values A, B, 0, 1, 1A, 1B, 2, etc. and in the order listed would be from oldest revision to the latest revision. Using the values provided, the formula would return "2". If my latest revision was "1A", then the formula would return "1A". The range A1:A7 is fixed so if there were more than 7 revisions, the 8th revision would overwrite the 1st revision.

Thank you for any help in advance.