Required formula|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Dear Sir /Madam, Good day,

Find herein enclosed Excel sheet for getting payments (Column L ) Draw back amount 1%  

from bank based on column E (scroll date).

Bank will transfer total amount sometime which we don’t know payment belongs to which Scroll date (column E).

Example: Bank transferred  INR. 33877.00 – towards  Cell number L130+L133 +L134 +L135 having different Scroll date.

How to find this Amount  INR . 33877.00  belongs to which scroll date using formula.  

Awaiting your reply.

Thanks & Best Regards

Kiran.