I have a data base
Column A is the part # and there are several other columns. I want to count
how many times a part # shows up on this list. I need a column to give me the
part # and the count. There are over 1000 different part #s. There's probably
a simple answer. I'm new to this though.

Any help would be great,
Mike

It seems like a Pivot Table would work for you:

DataPivot Table
Use Excel
Select your data
Click the [Layout] button

ROW: Drag the Part Number field here
DATA: Drag the Part Number field here
If it doesn't list as Count of Part Number...dbl-click it and set it to Count
Click [OK]

Select where you want the Pivot Table...and you're done!

That will list each Part Number and the count.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Cube Farmer" wrote:

I have a data base
Column A is the part # and there are several other columns. I want to count
how many times a part # shows up on this list. I need a column to give me the
part # and the count. There are over 1000 different part #s. There's probably
a simple answer. I'm new to this though.

Any help would be great,
Mike

Yeah Ron,
I was trying to make it harder than it had to be.
Thanks for the wakeup.
Mike


"Ron Coderre" wrote:

It seems like a Pivot Table would work for you:

DataPivot Table
Use Excel
Select your data
Click the [Layout] button

ROW: Drag the Part Number field here
DATA: Drag the Part Number field here
If it doesn't list as Count of Part Number...dbl-click it and set it to Count
Click [OK]

Select where you want the Pivot Table...and you're done!

That will list each Part Number and the count.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Cube Farmer" wrote:

I have a data base
Column A is the part # and there are several other columns. I want to count
how many times a part # shows up on this list. I need a column to give me the
part # and the count. There are over 1000 different part #s. There's probably
a simple answer. I'm new to this though.

Any help would be great,
Mike

You could try this:

=COUNTIF(A:A,A1)

Entered in the last column, and copied down as needed.

Doesn't create a unique list, but gives you the count of the part number in
each row.
--

HTH,

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

"Cube Farmer" wrote in message
...
I have a data base
Column A is the part # and there are several other columns. I want to count
how many times a part # shows up on this list. I need a column to give me
the
part # and the count. There are over 1000 different part #s. There's
probably
a simple answer. I'm new to this though.

Any help would be great,
Mike