Hi all,
I have a long list of several thousand assets, and each will have a condition survey recorded periodically.
What i'm trying to figure out is a elegant way to flag up in an adjacent column which is the most recent survey for that specific asset.
I have attached a very simplified sheet, with some dummy data - for this simple example that would look like a flag in Col D , indicating which is the most recent record for "cat", "dog" & "fish"
many thanks in advance.
I have a long list of several thousand assets, and each will have a condition survey recorded periodically.
What i'm trying to figure out is a elegant way to flag up in an adjacent column which is the most recent survey for that specific asset.
I have attached a very simplified sheet, with some dummy data - for this simple example that would look like a flag in Col D , indicating which is the most recent record for "cat", "dog" & "fish"
many thanks in advance.