Hi All,
I have an issue that I am unable to shake off. I require an array to give me the earliest maturity date based on two criteria. Going forward, I also want to be able to get 2nd earlist maturity and 3rd earliest maturity.
<tbody>
</tbody>
I've played with a few prototypes below:
<tbody>
</tbody>
If I use one cirteria only, it works fine. I need to have two criterias as my bigger file have multiple columns, and the last value/formula is where I am stuck.
Also, though the current formula says 114-118 (which includes blanks); my bigger files will be formulae changed to columns eg G114:G118 will become G:G and this will obviously have blanks .
Any help/advise on this will be appreciated.
Thank you
AQ
I have an issue that I am unable to shake off. I require an array to give me the earliest maturity date based on two criteria. Going forward, I also want to be able to get 2nd earlist maturity and 3rd earliest maturity.
Entity Name | Pay or Receive | Maturity date |
APPLE | RECEIVE | 6/11/2017 |
APPLE | RECEIVE | 27/11/2017 |
APPLE | RECEIVE | 27/12/2017 |
APPLE | RECEIVE | 16/01/2018 |
<tbody>
</tbody>
I've played with a few prototypes below:
<tbody> </tbody> |
<tbody>
</tbody>
If I use one cirteria only, it works fine. I need to have two criterias as my bigger file have multiple columns, and the last value/formula is where I am stuck.
Also, though the current formula says 114-118 (which includes blanks); my bigger files will be formulae changed to columns eg G114:G118 will become G:G and this will obviously have blanks .
Any help/advise on this will be appreciated.
Thank you
AQ