MissingInAction
Board Regular
- Joined
- Sep 20, 2019
- Messages
- 85
- Office Version
- 365
- Platform
- Windows
Hi. I have a list of unique IDs (column A) with different dates in column B, C and D. If one of the dates are 1 year old, or older, I want the ID and the age (today() - date in column B, C, D) to be presented in a list in Column I (ID) and Column J (age of date), up to a maximum of 10 results. I currently have an xlookup that does the work for me, but xlookups cant really handle multiple results. I did some Googling and found that Index might help, but I have no knowledge of this formula and online resources aren't very helpful with explaining the Index function.
I have added a screenshot that shows what my formula looks like for cell I2 and J2.
I have added a screenshot that shows what my formula looks like for cell I2 and J2.