Terminé

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

en voir plus : can't find circular reference in excel, there are one or more circular references where a formula refers to its own cell either directly, how to find circular reference in excel 2013, circular reference warning keeps popping up, how to remove circular reference in excel 2016, microsoft excel cannot calculate a formula there is a circular reference in an open workbook, allow circular reference excel mac, how to find circular reference in excel 2007, excel formula day count mortgage payments, adjust an existing excel formula, i have 60 business cards which i need the data to be entered into an excel sheet each category to have, i have a book of names and phone numbers of hospital employees that i need entered into an excel spreadsheet, i have a requirement for copying & pasting contacts information from a website onto an excel sheet which i will provide i have u, i have a requirement for copying & pasting contacts information from a website onto an excel sheet which i will provide, i have a requirement for copying pasting contacts information from a website onto an excel sheet which i will provide i have upl, i have a requirement for copying pasting contacts information from a website onto an excel sheet which i will provide, i have about 225 emails from which i need to have certain information transferred to an excel sheet there are 4 fields that i ne, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s

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
(76 Commentaires)
6.7

35 freelance font une offre moyenne de $335 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
(182 Commentaires)
7.6
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
(203 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
(60 Commentaires)
6.7
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
(259 Commentaires)
6.5
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
(91 Commentaires)
6.2
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
(65 Commentaires)
5.5
periyannas

Ok Sure

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(60 Commentaires)
5.5
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
(48 Commentaires)
5.1
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(42 Commentaires)
4.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
(46 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
(38 Commentaires)
5.1
Mfaisalshahzad00

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
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
(10 Commentaires)
3.5
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
dataexplorer

"Hello, I am happy to inform you that I have read your project "An Excel Formula to eliminate Circular Payments" description and understood all of your required requirement. I'd like to help you with confidence and s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(9 Commentaires)
2.9
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
(6 Commentaires)
2.7
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
(5 Commentaires)
2.4
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
(2 Commentaires)
0.7
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