Do some Excel Work
$30-250 USD
Pagado a la entrega
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 !
Nº del proyecto: #6215465
Sobre el proyecto
18 freelancers están ofertando un promedio de $80 por este trabajo
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 Más
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 Más
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 Más
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 Más
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 Más
- 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