An Excel formula to find and remove circular payments
$30-250 USD
Cancelled
Posted over 5 years ago
$30-250 USD
Paid on delivery
I develop business logic in Excel
I need a formula to scan several hundred transactions to find any circular payments:
For example
A pays B, B pays C, C pays D, D pays E, E pays F, F pays A
it needs to remove from each payment the smallest circular amount.
For example:
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.
The formula reduces A, B, C, D payments by 10
Dear Employer,
I understand yor circular payment reduction job. I will create an app which you can use to reduce such transactions. Please message me
Rates are flexible.
Thanks and Regards,
Ash
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
Hi,
What you need cannot be done with formulas unfortunately as this logic would definitely produces circular references. However I can write a VBA script that automatically does this and if you want it create an output of what changes have been made on the records.
Regards,
Balint
Hi,
As you want development of solution which can detect circular payment in the multiple transaction in Excel. I will design this solution for you. I have multiple years of experience of Excel, formulas and VBA macros. For this solution if required I will develop macro for you. Please share the excel sheet so that I can check and do this work for you.
Thanks,
Mohan
Hello there,
This looks feasible and I can do this quickly.
I have developed more than 500 VBA macros for Windows/MAC
I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience.
Ping me to discuss project , timeline and budget.
Thanks
A
Hi,
I am interested in discussing this task. I have over 5 years of experience working with Excel and can perform the task with accuracy and speed. Looking forward to hear from you to proceed further and start off.
Best Regards,
Akila.K
I have excellent command on MS Excel and can write a macro to remove circular payments.
I have completed complex projects in Excel before . For instance
- Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites
- Buy and sell bitcoins on Coinfloor and GDAX using respective APIs
- Built a POS and inventory management system
- Built a hotel price comparison that pulls data using the website's API
You can see the reviews of the same in my profile
Thanks,
Archana
Hi,
Good Day!
I can help you to complete this project.
I am a VBA Macro developer and has strong knowledge in MS Excel formulas and functionality.
I am also a PMO Analyst and my primary task is to generate and analyze a Financial Reports.
You can check my reviews to help you decide.
Feel free to message me anytime to discuss this project. Thank you
Hello, I hope you are well.
These are my strengths:
Immediate availability.
Responsible, fast and accurate.
Full-time freelancer.
Excel expert.
100% satisfaction guaranteed.
Available to any help after completion.
Experience of 7 years using excel for organizing and analyzing any company variables.
Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
Can I see the file please?
Hi!
I'm interesting your project very well.
I am mastering excel and algorithm.
And also I have many experience and good skill about web development.
Let's go ahead with me
I am expert in Excel and will do it right now.
I am ready to start work if you hire me. Please contact so we can start work together.
You can contact me 24*7 as i am full time individual Freelancer.
I am looking forwards working with you.
Thanks