KMunroe
New Member
- Joined
- Oct 31, 2008
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
I am hoping some of the excel experts on this site can help me with an xmatch challenge i am having. I am trying to see if there is a way to use an xmatch to return the 2nd or 3rd instance of a list of dates without using a helper column.
I want to be able to look up a date and the instance number and have the xmatch formula return the ordinal position of that date and instance numbers... I have been struggling with this for several hours. Any help would be greatly appreciate3d.
Here is what I was trying to do.
I want to be able to look up a date and the instance number and have the xmatch formula return the ordinal position of that date and instance numbers... I have been struggling with this for several hours. Any help would be greatly appreciate3d.
Here is what I was trying to do.