View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] genesisoxygen@gmail.com is offline
external usenet poster
 
Posts: 12
Default How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C

How can i have all alike product codes in column (A) be matched with
like cities in column (B) and then add the totals that are in column
(C)

Please help me I have 20,000 rows that needs done

Example:

SR1015 New Boston 10
SR1015 New Boston 5 15
SR1015 Coal Grove 5
SR1015 Coal Grove 20
SR1015 Coal Grove 5 30
BD0600 New Boston 30
BD0600 New Boston 10
BD0600 New Boston 10
BD0600 New Boston 10 60
BD0600 Coal Grove 250
BD0600 Coal Grove 50 300