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