Data Anlysis
$30-250 USD
Paid on delivery
I have two worksheets with lots of data
I need the first set of data to be matched agains the second.
I need this to be done manually to be sure
There are 1085 entries to check
Sheet one is a list of projects
Sheet two is a list of payments for those projects
Both have a matching project ID
Job is to match the payments to the projects
Some projects may have more than one payment
JOBS
1. In the project sheet create extra columns
Payment 1, Date, Amount, Amount in GBP 1, payment ID, Payment 2, Payment Date, payment id 2, Amount in GBP 2, Amount, Payment 3, Amount in GBP 3, Date, Amount, payment id 3
2. Look at the first payment in the payment sheet
Find the project and enter the payment into the first payment column adding the date, amount, amount in GBP (you will need to calculate) and payment id
Do this for each row in the payment sheet
If you find a second payment for a project the add it to the second set of columns Payment 2, Date 2 etc
3. Make a note or mark any payment in the payment sheet which you cannot find the project for
4. Bids
Now compare the bids
Project ID: #6636429
About the project
Awarded to:
Hello sir..i am interested on this project and ready for start now.......Please Provide me the excel sheet.........i will do this job for you with in time and with out doing and single mistake........Sir believe in lon More
37 freelancers are bidding on average $105 for this job
sir, i am highly interested and dedicated to do this task. let's discuss and start. i am awaiting for your positive reply. thanks
Hi there. I would be able to deliver the project in 2 days. I have read the description and I would like to discuss a few points. Kindly discuss. Regards.
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More
Hello, I believe i have the necessary skills to provide you a good work. My bid is $100 f. Timeframe: 4 days (negotiable acording to your needs). Looking forward to have an opportunity to work in your project . More
I've 2 years of experience working as a Data Entry Operator and Analyst in BRB International Agency. See My Profile. I'VE CLEARLY UNDERSTAND YOUR INSTRUCTIONS AND THE PROJECT. Your work'll be submitted in 3 days More
Hi Experienced and expert data manager here I can easily do this job, I will start right now Looking forward to hear from you Thanks Fahad
Hello, i am expert in this type of jobs i will do a script to do the matching required then i will review it manually to check that it is correct can begin now payment after job completion waiting your More
Hi, Thanks for checking my proposal. I have worked for several Data Analysis & Management assignments in the past. References available to show related skills. Quoting Negotiable price range & can work per More
Hi, I have already worked on such a project, where you have a more than one matching values. It can be done using "if" and "vlookup" function together. If you can upload a sample I can show you what I mean. Als More
Read my Cv in my portofolio section, if you are impressed hire me ! i think i am the best candidate for this job, if you want me to i can start right now
i am a good secretary and i am use to such job in excel sheet, i run petty cash and finance check report and for this job, such skills are required. if you hire me now i am sure to deliver the job properly done and on More