Do some Excel Work
$30-250 USD
Paid on delivery
Need to sum and transpose the data from about 1600 rows. This is a ledger that was pulled from Quickbooks. I have done several examples to guide you. The following instructions use rows 15 to 25 as an example. There are about 130 groups of data (the example set of rows 15 to 25 is one group), each group is identified by the label in column B. We will need to use the data in columns B through J to populate the summary in columns L through R. So with the data from rows 15 through 25 and columns B through J, this is how each of the result rows L through R should be completed:
Column L: Is the date of the "show" which should be the common denominator per column G in the data group.
Column M: is the label of the data group, which is in column B
Column N: is the sum of column J when column H indicates "Musicos" for the data group
Column O: is the sum of column J when column H indicates "Tecnicos" for the data group
Column P: is the sum of column J when column H indicates "Renta equipos" or "Equipos" for the data group
Column Q: is the sum of column J when column H indicates "Comision" for the data group
Column R: is the sum of column J when column H indicates "DJ" for the data group
Column S: is the sum of column J when column H indicates anything else other than the above for the data group
THANKS !
Project ID: #6215465
About the project
18 freelancers are bidding on average $80 for this job
Hi. I am an excel professional and rated best service provider in excel projects. I checked attached spreadsheet. Everything is well explained and I understood everything. Project will be completed within 36 hours of p More
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hi I’ve gone through your requirement, I am very confidence that I can do this task well. I do have expertise in the specified area. I am very much interested to work with you on this project. Please respond me so th More
Hi, I fully understood what is your need about in this worksheet. I am sending a sample. Please check. Line#: 105 to 112 Date Client musicos tecnicos Equipos More
Dear PM Sir, I need this Job. I am working as a Data Entry Operator for the past 10 years. I will do your work within the time with accuracy. Please send me the work. THANKING YOU
I deemed myself pretty familiar when it comes to data manipulation in excel. The job description you posted seems like best suited for pivot table function of the excel, not sure why you would rather have it done t More
I bid this job because i have already worked on the same job but in another company. This is a chance to show you what i am capable of. expect in-time delivery.
Hello Client, A Highly Qualified Web Researcher, Personal Assistant and Admin Assistant here. A freelancer with more than 5 years experience hands-on experience in office administration handling. Knowledge in Data e More
- I have 5 years experience in accounting and auditing - I am very good at working detail and have excellent excel skill
Good Afternoon! I'm a part-time student from the Philippines that is a whiz in Excel. Please consider me for this job, thanks! Sincerely, Sedric Chua
I am quite conversant with Ms excel and comfortable on working with it. I have also a good speed of typing
