# 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.

Evner: Excel

Om arbejdsgiveren:
( 1 bedømmelse ) Centerville, United States

Projekt ID: #17750962

## Tildelt til:

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 Flere

\$294 USD på 1 dag
(76 bedømmelser)
6.7

## 35 freelancere byder i gennemsnit \$335 på dette job

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 in 2 dage
(182 bedømmelser)
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 Flere

\$500 USD in 3 dage
(203 bedømmelser)
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 Flere

\$500 USD in 5 dage
(60 bedømmelser)
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

\$300 USD på 1 dag
(259 bedømmelser)
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 Flere

\$294 USD in 10 dage
(91 bedømmelser)
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

\$250 USD in 2 dage
(65 bedømmelser)
5.5
periyannas

Ok Sure

\$317 USD in 3 dage
(60 bedømmelser)
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]

\$250 USD på 1 dag
(48 bedømmelser)
5.1
\$250 USD in 3 dage
(42 bedømmelser)
4.9
rinabuoy13

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

\$277 USD in 10 dage
(46 bedømmelser)
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 Flere

\$250 USD på 1 dag
(38 bedømmelser)
5.1

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 Flere

\$750 USD på 1 dag
(17 bedømmelser)
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 Flere

\$250 USD in 2 dage
(10 bedømmelser)
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

\$250 USD på 1 dag
(15 bedømmelser)
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 Flere

\$400 USD in 14 dage
(9 bedømmelser)
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 Flere

\$250 USD på 1 dag
(6 bedømmelser)
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 Flere

\$250 USD på 1 dag
(9 bedømmelser)
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 Flere

\$333 USD på 1 dag
(5 bedømmelser)
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.

\$250 USD på 1 dag
(2 bedømmelser)
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 Flere

\$300 USD in 10 dage
(1 bedømmelse)
0.6