Hi,
I have a table which may contain more than one row per identifier, such as:
3 122
2 44
3 20
1 50
1 99
3 106
I need to sum up all right-column values referring to the same identifier, into an array which would look like this:
1 149
2 44
3 248
vlookup returns only the first instance of each value.
How can I collect all instances for the sum (preferably without sorting table 1)?
Thanks.
Bookmarks