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

Kemahiran: Excel

Lihat lagi: 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

Tentang Majikan:
( 1 ulasan ) Centerville, United States

ID Projek: #17629985

12 pekerja bebas membida secara purata $118 untuk pekerjaan ini


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 dalam 3 hari
(110 Ulasan)

"""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 Lagi

$60 USD dalam 3 hari
(156 Ulasan)

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 Lagi

$190 USD dalam 3 hari
(100 Ulasan)

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 Lagi

$166 USD dalam 3 hari
(158 Ulasan)

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 dalam 0 hari
(77 Ulasan)

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 Lagi

$99 USD dalam 3 hari
(46 Ulasan)

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 Lagi

$100 USD dalam 2 hari
(65 Ulasan)

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 Lagi

$100 USD dalam 2 hari
(32 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(25 Ulasan)

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 dalam 3 hari
(1 Ulasan)

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 Lagi

$30 USD dalam sehari
(9 Ulasan)

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 Lagi

$55 USD dalam 0 hari
(0 Ulasan)