Hi Folks. I have 2 columns of info, 'A' contains quantities and 'B'
contains product name. The same product appears multiple times in
column B, with a respective quantity of the product in the same row in
column 'A'. For example, row 1 may detail 15 apples, row 2 may contain
12 bananas, etc. IF row 3 also has apples, say with a quantity of 5
apples and row 4 has bananas with say a quantity of 6, how do I
consolidate the data to to present a total of 20 apples and 18 bananas?
I hope my simple analogy is clear. I would ideally like the info
presented as a consolidated list, ie row 1 = 20 apples; row 2 = 18
bananas. Any assistance available would be readily and gratefully
received. Thx. AJ Fletcher