An Excel Formula to eliminate Circular Payments
$250-750 USD
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.
ID projekta: #17750962
Več o projektu
33 freelancerjev ponuja v povprečju za $334 na tem delu
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
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
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č
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č
Hello, I am experienced excel professional. I can help with this task. Looking to hearing from you. Kind regards
I have excellent command on MS Excel formulas and I can write a formula to eliminate the circular payments in the sheet
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č
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č
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č
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
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č
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č
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č
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č
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č
with in 3 days i will completed this project and honestly handed over to you. thanks for your understand Ranjit