Morning,
I've been trying to figure this out for days now and I'm getting nowhere fast and no matter how much googling I do I just can't find something that does what I need.
I have a very basic worksheet, albeit with 200 rows, that includes names and the dates that their contracts are due to be renegotiated - this will be updated as the contract dates change so the dates aren't static. I want to have a worksheet that shows the next five dates (there can be multiple entries with the same date) where contracts are due to end. The closest I've been able to get so far is to at least pull out the dates by using
through to 5 but can't figure out how to now match the dates pulled out by that to make Excel (2003 btw) copy the relevant rows in to my 'Due dates' worksheet.
Thanks for any advice!
Sy
I've been trying to figure this out for days now and I'm getting nowhere fast and no matter how much googling I do I just can't find something that does what I need.
I have a very basic worksheet, albeit with 200 rows, that includes names and the dates that their contracts are due to be renegotiated - this will be updated as the contract dates change so the dates aren't static. I want to have a worksheet that shows the next five dates (there can be multiple entries with the same date) where contracts are due to end. The closest I've been able to get so far is to at least pull out the dates by using
Code:
=SMALL('Contracts'!$A$2:$A$206,1)through to 5 but can't figure out how to now match the dates pulled out by that to make Excel (2003 btw) copy the relevant rows in to my 'Due dates' worksheet.
Thanks for any advice!
Sy
