Hello,
In Google Sheets...
I am trying to take the below data table and, with a single formula, consolidate it into the example result table below.
The formula would look at the data table and basically look for unique combinations of first and third columns and then sum up column 2 for those instances that match those combinations.
I would want the results to be sorted by Column 3 then by Column 1 automatically if possible, but the sort I can do after manually or with a macro later.
Most important part is just getting the data in the result table regardless of sort.
Thank you!
In Google Sheets...
I am trying to take the below data table and, with a single formula, consolidate it into the example result table below.
The formula would look at the data table and basically look for unique combinations of first and third columns and then sum up column 2 for those instances that match those combinations.
I would want the results to be sorted by Column 3 then by Column 1 automatically if possible, but the sort I can do after manually or with a macro later.
Most important part is just getting the data in the result table regardless of sort.
Thank you!
DATA TABLE | RESULT | ||||||
BOB | 1 | A | BOB | 6 | A | ||
BOB | 2 | A | BILL | 14 | A | ||
BOB | 3 | A | JOHN | 3 | B | ||
BILL | 2 | A | FRANK | 9 | B | ||
BILL | 3 | A | JIM | 26 | B | ||
BILL | 4 | A | |||||
BILL | 5 | A | |||||
JOHN | 3 | B | |||||
FRANK | 4 | B | |||||
FRANK | 5 | B | |||||
JIM | 5 | B | |||||
JIM | 6 | B | |||||
JIM | 7 | B | |||||
JIM | 8 | B |
Last edited: