Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 295
- Office Version
- 365
- Platform
- Windows
I have been trying to identify how to compare a string and return if it is latest version. I have a large amount of data that looks like:
I have a column of "data" that has a letter at the end of the string. If it is a letter, the largest letter (F>A) is the latest revision. If there is a data point with no letter, but the precursor has a letter, it is obsoleted. (i.e. Route 921 and Route 921 A. Route 921 A is the latest and Route 921 is obsolete.)
I have a column of "data" that has a letter at the end of the string. If it is a letter, the largest letter (F>A) is the latest revision. If there is a data point with no letter, but the precursor has a letter, it is obsoleted. (i.e. Route 921 and Route 921 A. Route 921 A is the latest and Route 921 is obsolete.)
Sage Tables Created 2023-09-19.xlsx | ||||
---|---|---|---|---|
AH | AI | |||
1 | Data | Latest Rev? | ||
4 | Route 1234 A | No | ||
5 | Route 1234 B | Yes | ||
9 | Route 1234 | No | ||
10 | Route 5567 D | No | ||
14 | Route 5567 F | Yes | ||
15 | Route 921 A | No | ||
16 | Route 921 | No | ||
17 | Route 921 F | Yes | ||
FMI - Route Tool Code Upload 9- |