This involves Excel 2003. We have an Excel file with thousands of
records(rows) and one of the fields(columns) is called PRODUCT ID. There are
many, many different PRODUCT ID numbers that can be entered into the column.
I would like to see how many times each PRODUCT ID number is entered in the
file. What I want is some kind of list showing each PRODUCT ID number along
with the count.
For instance:
PRODUCT ID COUNT
A12345 014
A56789 056
B83741 132
C28294 089
etc.
etc.
etc. down to the last number in the file
Y73958 105
Z43002 043

Is there a way to get these counts for a column in a file??
Thank You Very Much