Combine quantity of identical product names

[n8custerwv]

I am posting from my phone and can't send example.

I have 2 columns with drop down selections of screw sizes in each cell. When you select a screw size from the drop down menu, the size is shown in that particular cell and also the size is autopopulated to a certain cell on a seperate tab (billing sheet.) My billing sheet has all the data from the drop down selections but I can't figure out how to merge identical sizes and increase the quantity. So basically on my sales sheet, i would like to have a quantity cell before the sizes that would automatically increase by 1 each time a identical screw was selected from my drop down lists in the other sheet.

Does this make sense?


Is there a easy way to accomplish this?

Thanks!

[MarvinP]

Hi Nate,

It is almost mandatory that you show us a sample for us to understand the problem. When you get to a computer, click on "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area to attach a sample file.

Then we can open it and see what and where your dropdowns and invoice and sizes are all about.

[n8custerwv]

Thanks for the reply. I sent you a pm but think I can simplify what I am trying to do

Col1
5.5 poly
5.5 poly
5.5 poly
5.6 reduction
4.0 uni
5.6 reduction
4.0 uni

Need to combine the ones that are the same with the quantity before. (see below)

3-5.5 poly
2-5.6 reduction
2-4.0 uni

[MarvinP]

HI this looks like a simple pivot table. You drag the Col a to the row area and drag it to the Sum area and let it count.
http://www.excelfunctions.net/Excel-Pivot-Tables.html or
see http://www.csd509j.net/district_info...vot_tables.pdf or

[n8custerwv]

Very much appreciated!!