Sum up excel columns by Part #
$10-30 USD
Pagato alla consegna
I have two separate excel sheets that I need data summed up. There is a quantity column and a Vendor Part number column. These represent each individual sale of a Vendor Part #. I need the quantity column totaled by Part #.
For example the spreadsheet Special Order Sales has the following items:
1 BMP3422068C
1 BMP3422068C
2 BMP3422068C
1 BMP3422068C
1 BMP3422068C
1 BMP3422068C
1 BMP3422068C
1 BMP3422068CSO
I want this to show up in a seperate tab as
7 BMP3422068C
1 BMP3422068CSO
If it could be done where I could collapse all of the items of each part number and just have a total row for each individual part #, that would be great.
I hope this makes sense. I believe it is a very simple project. I Just do not know the best way to do it and am wasting a lot of time trying to figure it out.
I will award this project based on price, of course, but also who can get it done immediately.
Rif. progetto: #18550426
Info sul progetto
Assegnato a:
Hello Vinval, It is very simple task and i can sum up these with excel formulas. I have 5 years experience in advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc. I never ask for payme Altro
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I can deliver this projec Altro
11 freelance hanno fatto un'offerta media di $24 per questo lavoro
HI, I am good at Excel and pivot tables. I see your requirement. I can summarize the data using pivot table quickly as required. Looking forward to work on this and provide quick turn around. -Chandra
Hello! Ican resolve this using a VBA script. I can finish in 1-2 hours max. Thank you! I am ready to start now.
sure i can do it right now sure i can do it right now sure i can do it right now sure i can do it right now
Hello client I can do the task fast. I understand what is required to be done. Please contact mme. Roy
Hello? How are you? I have good experiences in "Sum up excel columns by Part #" as you can see my profile for these (Data Entry, Data Processing, Excel). I have been working for 7 yrs in this scope. While we contra Altro
Hi I have written a lot of Python script to process any CSV/Excel fields. I can do this quickly. Please send me a message. You can check my reviews for more info. :) Thanks
Please give this work to me. Relevant Skills and Experience I am good in word and excel. So I can do this work with full accuracy