ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 343
- Office Version
- 365
- Platform
- Windows
Sirs,
Need to extract values of the 2nd to the last matching criteria.
Need a formula in cell H4 that will extract the dates in column A (2nd to the last of the matching criteria) that is based on 2 criteria (name4 and number 3).
I have managed to extract the last match using xmatch. i am stuck on how to extract the 2nd to the last match..
Please see gsheet attached
Thank you very much,
Need to extract values of the 2nd to the last matching criteria.
Need a formula in cell H4 that will extract the dates in column A (2nd to the last of the matching criteria) that is based on 2 criteria (name4 and number 3).
I have managed to extract the last match using xmatch. i am stuck on how to extract the 2nd to the last match..
Please see gsheet attached
Untitled spreadsheet
docs.google.com
Thank you very much,