Thread: auto grouping.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bduncan bduncan is offline
external usenet poster
 
Posts: 20
Default auto grouping.

In column B I have our part numbers and in column A is our serial numbers.
Is there a way I can group the serial numbers with the correspondingpart
number with out doing this manually. Not every product number has serial
numbers and the products that do may have only one serial number or many
serial numbers depending on the quantities.
Serial # Product #
104-214100
4243232
4334532
104-214101
104-214103
5342322