I just joined the forum to learn the same technique ... I've actually worked around the critical issue and wanted to ask about the best techniques to sum a table with a key in "column A". I may experiment with Pivoting tables also.
INPUT ROWS
A-B-C---columns
A 1 $10
A 2 $20
B 1 $10
C 1 $50
C 2 $25
C 3 $25
OUTPUT ROWS
(I'd like to either summarize the total in another blank column on the spreadsheet, even with blank cells between them where the duplicate keys exist ... I don't need to place the key in a field, just the overall total)
D-E---columns
A $30
B $10
C $100
Bookmarks