I am trying to find a function, or a series of functions, that allow me to:
(1) Identify if any cell in column A matches any other cell in column A,
(2) add numbers in Column B that occupy the same rows as the matches in column A, and
(3) merge matches rows or delete duplicate rows.
This example will work to explain what I'm trying to get:
I would like to do this WITHOUT having to assume Apples, Oranges, and Bananas are my only fruits. For instances, if two Grapefruit were to appear, I'd like the function to work automatically without having to write a different formula to include Grapefruit.
Is this possible or if not, what are some workarounds?