Hi there,
So I have a database of contracts, but some appear more than once, ie they may have more than one contract period, so they would have numerous lines in my spreadsheet with differing start and finish dates.
I'm doing a bit of a purge on our Purchase orders linked to these contracts and was wanting to pull in the names of the individuals and their latest contract end dates. Issue is mainly down to the fact that the same PO is extended when a new contract period starts, if a new PO was raised I wouldn't have this issue.....whahay to internal process...
I'm using Index Match, Parameter 0 Exact, but this is bringing back the first occurrence it finds, which for some contracts is incorrect.
Can anyone help me with a way to add more criteria to bring back the latest date?
Thanks
seash
Bookmarks