I need a formula that will take the most recent and second most recent dates and return the description for that date. I have a simple example of what I need and in F2 I want the Most recent date description and in F3 I want the second most recent date description.
Thank you for your help.
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Date | Column 1 | Column 1 | Description | Return | |||
2 | 12/12/2023 | Test 1 | Test 4 | |||||
3 | 12/22/2023 | Test 2 | Test 3 | |||||
4 | 1/5/2024 | Test 3 | ||||||
5 | 1/15/2024 | Test 4 | ||||||
Sheet1 |
Thank you for your help.