An Excel formula to find and remove circular payments

I develop business logic in Excel

I need a formula to scan several hundred transactions to find any circular payments:

For example

A pays B, B pays C, C pays D, D pays E, E pays F, F pays A

it needs to remove from each payment the smallest circular amount.

For example:

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.

The formula reduces A, B, C, D payments by 10

Skills: Excel

See more: how to find circular reference in excel 2007, how to find circular reference in excel 2016, how to find circular reference in excel 2013, can't find circular reference in excel, microsoft excel cannot calculate a formula there is a circular reference, how to remove circular reference in excel 2010, allow circular reference excel mac, how to remove circular reference in excel 2016, call web service excel formula, excel formula sheet, microsoft excel formula sheet, check excel formula aspnet, excel read remove, excel formula convert utm latitude, excel formula projects, excel formula network address range, excel formula capture data time day, accounting excel formula, excel formula call web service, excel formula expertise

About the Employer:
( 1 review ) Centerville, United States

Project ID: #17629985

12 freelancers are bidding on average $118 for this job


Dear Employer, I understand yor circular payment reduction job. I will create an app which you can use to reduce such transactions. Please message me Rates are flexible. Thanks and Regards, Ash

$250 USD in 3 days
(110 Reviews)

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$60 USD in 3 days
(156 Reviews)

Hi, What you need cannot be done with formulas unfortunately as this logic would definitely produces circular references. However I can write a VBA script that automatically does this and if you want it create an ou More

$190 USD in 3 days
(100 Reviews)

Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. P More

$166 USD in 3 days
(158 Reviews)

Hi there, This can be done with the help of VBA. I can do the work and can deliver you within today. I will be able to start right now. Thanks.

$66 USD in 0 days
(77 Reviews)

Hi, As you want development of solution which can detect circular payment in the multiple transaction in Excel. I will design this solution for you. I have multiple years of experience of Excel, formulas and VBA mac More

$99 USD in 3 days
(46 Reviews)

I have excellent command on MS Excel and can write a macro to remove circular payments. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and More

$100 USD in 2 days
(65 Reviews)

Hi, I am interested in discussing this task. I have over 5 years of experience working with Excel and can perform the task with accuracy and speed. Looking forward to hear from you to proceed further and start off More

$100 USD in 2 days
(32 Reviews)

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com More

$155 USD in 3 days
(25 Reviews)

Hi! I'm interesting your project very well. I am mastering excel and algorithm. And also I have many experience and good skill about web development. Let's go ahead with me

$150 USD in 3 days
(1 Review)

Hi, Good Day! I can help you to complete this project. I am a VBA Macro developer and has strong knowledge in MS Excel formulas and functionality. I am also a PMO Analyst and my primary task is to generate and a More

$30 USD in 1 day
(9 Reviews)

I am expert in Excel and will do it right now. I am ready to start work if you hire me. Please contact so we can start work together. You can contact me 24*7 as i am full time individual Freelancer. I am lookin More

$55 USD in 0 days
(0 Reviews)