hi
I have some values in b5:b14 currency format, the same way C5:c14 date format. I need recently increased amount, which is increased and which date.
so please suggest which formula I can use for the scenarios.
Example 1 :
amount date
100 01/01/16
50 02/02/16
100 03/02/16
100 04/01/16
here increased value is 100 with date 03/02/16, this values I need in C4 and c5.
amount date
100 01/01/16
100 02/02/16
100 03/02/16
100 04/01/16
here there is no any changes in amount so it should be 100 with 01/01/16 in C4 and c5.