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

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

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

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 in
"select product id". use function "select count" , add subtotal to
"select count". - click ok.

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


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277028

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!
==============================================


"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