From: Jason on 28 Apr 2010 16:34 Hello everyone I would like excel to count how many same part numbers i have and list them. Such as P/N 11222=20, P/N 11333=30. Any suggestions? thx
From: Don Guillett on 28 Apr 2010 17:16 look in the help index for countif  Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Jason" <Jason(a)discussions.microsoft.com> wrote in message news:FC4194D74DD64D03B15E4FB34F689B84(a)microsoft.com... > 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
From: grizzly6969 on 28 Apr 2010 17:24 =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

Pages: 1 Prev: counting part numbers Next: '07 Large Operation Error (Delete / Insert Rows and/or Columns 