Try Data-Subtatals
and select count at each change in ProductID
You need to sort your file on ProductID first

"Foreplay_Man" wrote in message
...
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