countif question

C

Cube Farmer

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
 
R

Ron Coderre

It seems like a Pivot Table would work for you:

Data>Pivot 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
 
R

RagDyeR

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

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
 
C

Cube Farmer

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


Ron Coderre said:
It seems like a Pivot Table would work for you:

Data>Pivot 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 said:
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
Click to expand...
Click to expand...
 
Top