I have 2 columns with different data: column A with names, column B with different values. The same name can be used multiple times in column A.
I want to create a table with the total value (so the sum of the different values with the samen name) for each unique name.
Since Vlookup only shows me the first match and I need to sum of all matches, how can I do this? the number of rows can be infinite.
Bookmarks