ExcelBanter - counting part numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counting part numbers (https://www.excelbanter.com/excel-discussion-misc-queries/262678-counting-part-numbers.html)

Jason

counting part numbers

Hello everyone-
I would like excel to count how many same part numbers i have and list them.
Such as P/N 11222=20, P/N 11333=30.

Any suggestions?

thx

All times are GMT +1. The time now is 06:04 AM.