Hi
<colgroup><col></colgroup><tbody>
</tbody>
I would require a formula that will give me a last date which has payment. |
with the above data the result would be 11-Jan-2015 as it has the last payment made of 1000006 on 11-jan-2015. |
I tired the formula which give me INDEX(A:A,COUNTA(A:A)) but doesn't suffice the above condition. |
<colgroup><col></colgroup><tbody>
</tbody>
Excel 2012 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | DATE | PAYMENT | ||||
2 | 5-Jan-15 | 1,000,000.00 | ||||
3 | 6-Jan-15 | 1,000,001.00 | ||||
4 | 7-Jan-15 | 1,000,002.00 | ||||
5 | 8-Jan-15 | 1,000,003.00 | ||||
6 | 9-Jan-15 | 1,000,004.00 | ||||
7 | 10-Jan-15 | 1,000,005.00 | ||||
8 | 11-Jan-15 | 1,000,006.00 | ||||
9 | 12-Jan-15 | |||||
10 | 13-Jan-15 | |||||
11 | 14-Jan-15 | |||||
12 | 15-Jan-15 | INDEX(A:A,COUNTA(A:A)) | ||||
13 | 16-Jan-15 | 16-Jan-15 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D13 | =+INDEX(A:A,COUNTA(A:A)) |