An Excel Formula to eliminate Circular Payments

Končano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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.

Excel

ID projekta: #17750962

Več o projektu

33 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

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 Več

$294 USD v 1 dnevu
(118 mnenj)
7.3

33 freelancerjev ponuja v povprečju za $334 na tem delu

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

$294 USD v 2 dneh
(225 ocen)
7.9
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 Več

$500 USD v 5 dneh
(87 ocen)
7.1
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

$300 USD v 1 dnevu
(347 ocen)
6.9
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 Več

$500 USD v 3 dneh
(231 ocen)
6.9
periyannas

Ok Sure

$317 USD v 3 dneh
(109 ocen)
6.4
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 Več

$294 USD v 10 dneh
(112 ocen)
6.5
rinabuoy13

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

$277 USD v 10 dneh
(91 ocen)
6.0
archanaoswal

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

$250 USD v 2 dneh
(78 ocen)
5.7
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 Več

$250 USD v 1 dnevu
(52 ocen)
5.5
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 Več

$250 USD v 2 dneh
(29 ocen)
4.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 Več

$250 USD v 1 dnevu
(17 ocen)
4.6
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 Več

$333 USD v 1 dnevu
(24 ocen)
3.9
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

$250 USD v 1 dnevu
(24 ocen)
4.0
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 Več

$750 USD v 1 dnevu
(17 ocen)
3.9
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 Več

$250 USD v 1 dnevu
(11 ocen)
3.6
engraniaasaeed

I have read carefully the project, I can help you.

$277 USD v 1 dnevu
(1 Ocena)
0.0
karimkholy

Hello, I am a nanotechnology engineering fresh graduate who used to do similar projects in several topics using excel, and C programming language if necessary. I will do this task efficiently and as you want. I am new Več

$277 USD v 4 dneh
(0 ocen)
0.0
WarrenCConn

Hi, I checked your excel sheets. I think I can do this well I am very interested in this project. I have a lot of experience in this type of work. I'm sure I can complete it on time with high quality according to Več

$555 USD v 1 dnevu
(0 ocen)
0.0
ranaakram1

Good Day, How are you, I have twenty year experience in the field of finance and accounts books maintenance on accounting software QB etc, and audit every transaction through supporting documents which is very helpful Več

$250 USD v 10 dneh
(0 ocen)
0.0
bendalam

with in 3 days i will completed this project and honestly handed over to you. thanks for your understand Ranjit

$444 USD v 3 dneh
(0 ocen)
0.0