Dear Team,
Happy New Year to all ....
PFA the excel file showing the working of Limit and Outstanding bal.
I need to give a formula in col. M which allocates amount of cell M21 between cust ID "a" on rational basis.
Similarly, amount of cell M22 needs to be allocated between cust ID "b" and so on.
There is 1 condition.
Total amt in col N (Total O/s amt) should not exceed exposure limit in col D.
There are approx 50000 rows having diff. cust ID and A/c no. in the database.
Is there anyway we can automate this ?
Please help....
Bookmarks