I develop business logic in Excel and need a formula to scan several hundred transactions to find circular payments.
In the example, A pays B, B pays C, C pays D, D pays E, E pays F, F pays A the elimination formula needs to remove from each payment the smallest circular amount. (A pays 180 to B; B pays 30 to C; C pays 50 to D; D pays 10 to A: 10 is the smallest circular amount, so the formula reduces A, B, C, D payments by 10).
The new formula will go in Column G of the attached spreadsheet. Have a look at the formula in Column E -- this gives an idea of what is needed; it is a simple formula to eliminate a direct circular payment: A pays B and B pays A). The new formula will handle the advanced cases:
A pays B, B pays C, C pays D, D pays A, etc. There are 3 Test Cases -- the new formula will be able to pass each of these test cases, eliminating the circular amounts in each test.
PLEASE NOTE -- THIS IS NOT an EXCEL VBA MACRO PROJECT BUT AN EXCEL FORMULA PROJECT. While it's possible to write a VBA MACRO to accomplish this task, an Excel Formula is needed. PLEASE respond ONLY if you can WRITE AN EXCEL FORMULA to handle this task.
35 freelancere byder i gennemsnit $335 på dette job
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro VBA etc. thanks
a to f values are in excel sheet [login to view URL] you have any example [login to view URL] a to f any where payment will be down?how many formula you want 1 or 3. Relevant Skills and Experience i will do [login to view URL] are expert in it.