# An Excel Formula to eliminate Circular Payments

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.

Compétences : Excel

Concernant l'employeur :
( 1 commentaire ) Centerville, United States

Nº du projet : #17750962

## Décerné à:

zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to create this formula for you ! I can start immediately and finish it within t Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(87 Commentaires)
6.8

## 34 freelance font une offre moyenne de \$333 pour ce travail

Webxpert4u

I am ready yo write excel fourlma to eliminate circular payment in excel. I am 100 % sure I can do it. Please check my review. Thank You

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(200 Commentaires)
7.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(206 Commentaires)
6.8
dgled

HI, seems to me that in test 1 A paid to B 130 and S 50. Is it a rule that the last paying pay the minimum to the first paying? (you say "F pays A the elimination formula needs to remove from each payment the smallest Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(70 Commentaires)
6.8
TonmoyRoy111

Dear client I can build the formula for you in excel. I may need more than one formula to build the main formula. Kindly contact me. Roy

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(279 Commentaires)
6.6
ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(97 Commentaires)
6.3
periyannas

Ok Sure

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(73 Commentaires)
5.9
rinabuoy13

Hello, I am experienced excel professional. I can help with this task. Looking to hearing from you. Kind regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(57 Commentaires)
5.4
archanaoswal

I have excellent command on MS Excel formulas and I can write a formula to eliminate the circular payments in the sheet

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(69 Commentaires)
5.6
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(61 Commentaires)
5.3
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(43 Commentaires)
5.0
daniyal3214

I am a professional Excel expert holding years of experience in utilizing advance level formulas, functions and other tools of Excel to perform Financial Modeling, Business Analysis, Data Analysis, Automation and sever Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(42 Commentaires)
5.3
sevillajk01

hello! I would love to help you with your project. Just award the project to me and you can be assured of a quality and accurate output from me. And I have seen your spreadsheet and I am confident that I can deliver it Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(18 Commentaires)
4.2

Hi, I got the idea. 80% done. Just need to give final touch to formula. Maximum few hrs needed after confirmation. Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experien Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)
3.8
haleem0786

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(15 Commentaires)
3.6
rIbrarahmed

hi, I have checked your file and read your description as well and able to understand what you need, and now will able to do this work. I am very good in Excel vba, macro, chart etc. if you want to see my excel skill Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
3.2
ibrarulhaq

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
2.6
Nicecreator

Hi there, i understand your requirement and if you need a sample work,can provide within one hour. if you have any questions please let me know, can start now your project according to the your guide line with Con Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
2.4
maguirrer

Hi there, I can help you with your formula and send the file back as soon as possible. I check the xls file attached and I can do it. Please let me know if you can hire me to start working, almost nobody wants new free Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
2.4
general985

Hello sir. I'm excited about your project, because I've really rich experience in Excel Programming. I've developed many projects similar to yours and excellent skills. If you award me, I'll provide wonderful result Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
0.6
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0