counting part numbers
 

Hello everyone-
I have bunch of part numbers and I would like excel to tell me how many of
each part number I have.

let's say
P/N 11222= 1
P/N 11333= 2

counting part numbers
 

look in the help index for countif

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jason" wrote in message
...
Hello everyone-
I have bunch of part numbers and I would like excel to tell me how many of
each part number I have.

let's say
P/N 11222= 1
P/N 11333= 2

counting part numbers
 

=countif(A2:A100,"=11222")
assuming your part numbers are in column A
--
grizz


"Jason" wrote:

Hello everyone-
I have bunch of part numbers and I would like excel to tell me how many of
each part number I have.

let's say
P/N 11222= 1
P/N 11333= 2