View Single Post
  #1   Report Post  
Brian Connolly
 
Posts: n/a
Default Searching a list with repeat entries and creating a sum

I have an array (single column) of part codes with an assciated number of
parts in an adjacent column. Given that there may be duplicate entries in the
part code column, how do I create a new column of unique part codes (i.e each
part code listed only once in the column) and a second colum with the nummber
of parts associated with that part code.