EXCEL FORMULA HELP NEEDED. NO BIDS FROM INDIAPAK REGION BUDGET $20
$10-30 USD
Completed
Posted over 4 years ago
$10-30 USD
Paid on delivery
I need help with an excel spreadsheet creation with formulas
column 1 Transaction Date
column 2 Vendor name
column 2 Project name
column 3 Descrription
column 4 Expense
column 5 Capital
column 6 Balance
now to the difficult part:
column 7 has list of all vendors, example Joe, Bob, Peter
column 8 holds their totals
any time there is a transaction in column 4 , for whom the vendor is 'Joe', that amount must be added to the total on column 8 against Joe's total. So I made transaction for $500 on 3-9-19 and $200 on 3/11/19, then Joe's total on column 8 must show $700
column 9 lists all projects by name, example Dodge, Chevy, Benz
column 10 lists total amounts in each of these specific projects
any time there is a transaction in column 4, for which the project name is 'Dodge' that amount is added to the total on colum 10 against Dodge's total. So if the transaction I made for $500 with Joe on 3-9-19 was for the Dodge project and the transaction i made on 3-21 with bob for the Dodge project was for $100, then the dodge total will add up to $600
Hey, I am a professional excel user for past 10 years. i understood your task. Can help you out in 30 minutes.
have just started on freelancer platform and exited to engage with you as my first assignment.
Thanks
$10 USD in 7 days
5.0 (1 review)
1.4
1.4
13 freelancers are bidding on average $18 USD for this job
Hi,
I have understand the project requirement & interested to make formula for this project. Please send a message so we can discuss more & start the project.
Thanks.
In response to your post, I’d like to be considered for your data entry position. I’m a strategic data analysr with a strong background in developing online content. I can turn a phrase in a way that represents your brand and appeals to your target audience. Whether you need a formal, serious tone or a more playful one, I can make the transition with ease.
I am accustomed to working with all sorts of products and services in a variety of industries. I have a deep passion for research and guarantee that all of my entry is 100% original.
A sampling of an data sheet I’ve work on is attached below.
I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship.
Please, let me know what is needed to secure this bid!
Thank you for your consideration. Abdulmalik
Dear Employer: I can do your project in fixed time and with perfection.
If you'll hire me then this will be my first project on freelancer and I'll give my all effort for my good startup.
Hi,
It looks like the task wont take too much time, so I do bid minimum amount and will execute in couple of hrs..
Even more i can provide with some extensions to make the data input easier.
Hello,
i wrote my thesis with Excel and Excel VBA. In this case VBA is not required. I already know the formula. I can completely optimize your Excel.
I'm german and travel the world with my motorbike. We can help each other with that job...
Hope to get a positive answer.