Hi everyone,
I have a table with multiple entries for the same ID and different dates. I would like to return the most recent value associated with a specific ID.
For example:
sports games
If I look up A01, I want Excel to return 150 (the value from the latest date).
What formula would be the best approach for this in Excel 365? Thanks in advance for any help!
I have a table with multiple entries for the same ID and different dates. I would like to return the most recent value associated with a specific ID.
For example:
| ID | Date | Value |
|---|---|---|
| A01 | 01-Jan-2026 | 100 |
| A01 | 15-Jan-2026 | 120 |
| A01 | 20-Feb-2026 | 150 |
| B01 | 05-Jan-2026 | 80 |
If I look up A01, I want Excel to return 150 (the value from the latest date).
What formula would be the best approach for this in Excel 365? Thanks in advance for any help!