showing the # of times an item is entered in a column

[Foreplay_Man]

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

 

[N Harkawat]

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

 

[anilsolipuram]

Try this

1.Select the complete table. go to data -> sort select "sort by
product id -> click ok.
2. Select the complete table. go to data ->subtotal-> at each change i
"select product id". use function "select count" , add subtotal t
"select count". -> click ok.

You should be able to see each product id with its count

 

[RagDyeR]

Insert a "helper" column next to the product ID column, and enter this
formula:

=COUNTIF(A:A,A1)

Now, select the cell with this formula, and *double* click on the "fill
handle', which will *automatically* copy the formula down the column, as far
as there is data in the adjoining column.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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