Hello,
Have a column representing dates in order of months a security is in a portfolio. Some months the security is not in the portfolio. Would like a formula to capture the first month the security comes back in the portfolio after a break. Eg listed below the security is absent between Jan 2017- April 2017. Would like to capture in a cell the April 2017 formulaically.
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Appreciate any assistance.
Thank you
Have a column representing dates in order of months a security is in a portfolio. Some months the security is not in the portfolio. Would like a formula to capture the first month the security comes back in the portfolio after a break. Eg listed below the security is absent between Jan 2017- April 2017. Would like to capture in a cell the April 2017 formulaically.
Month | Security |
Jan-17 | YYYYY |
Apr-17 | YYYYY |
May-17 | YYYYY |
Jun-17 | YYYYY |
Jul-17 | YYYYY |
Aug-17 | YYYYY |
Sep-17 | YYYYY |
Oct-17 | YYYYY |
Nov-17 | YYYYY |
Dec-17 | YYYYY |
Jan-18 | YYYYY |
Feb-18 | YYYYY |
Mar-18 | YYYYY |
Apr-18 | YYYYY |
May-18 | YYYYY |
Jun-18 | YYYYY |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Appreciate any assistance.
Thank you