Counting one column to feed another

Hello I'm new to the forum but have a problem in excel. I work at a fab shop with a lot of orders and different parts needing to be scheduled all the time. I use excel to track and organize the whole process but want to automate a column of part numbers into another column that list how many of each part is contained in the first column.

Excel Count Column.jpg

As shown in the picture, it needs to scan one entire column, count how many of each like numbers there are and feed that to another column of parts and quantities. Does anybody know how to do this in a Macro or formula? Or any suggestions on how I might accomplish such a task?

The formula you need is the countif function. In I3 the formula would be:
=COUNTIF(B:B,H3)
And just copy that down for the parts in column H.

In order to auto-sort by the largest quantity as the count changes, you'll need some VBA. Put the following code in the Worksheet object where you data is and that should do it.

Please Login or Register  to view this content.

Hope that helps. MM.

Hi Brian - yes, this can be done ... I'll need to code it and I should have it ready shortly.

Replace the previous code with the below and that should do it.

Please Login or Register  to view this content.

You may not have actually pasted it where you think you did ... try double-clicking on the Sheet1 object and then paste.

Hi Brian. In the top left corner of the screen shot, you'll see it has the file name: "Example count file.xlsx". The xlsx extension is not a macro-enabled workbook. You need to save it with an xlsm file extension.