C
consultant_of_swing
I have a worksheet that contains invoice information at the detail
level.
VEND_CODE | INV_NUMBER | INV_DATE | LINE_AMOUNT
123 123-A 3/5/08 100.00
123 123-A 3/5/08 200.00
456 456-B 3/31/08 500.00
456 456-B 3/31/08 800.00
456 456-C 4/2/08 700.00
I need to build a second worksheet that summarizes the amount by all
the other columns
VEND_CODE | INV_NUMBER | INV_DATE | INV_TOTAL
123 123-A 3/5/08 300.00
456 456-B 3/31/08 1300.00
456 456-C 4/2/08 700.00
This would be a simple select query with a group by clause in SQL, but
I'm at a loss as to how to accomplish it in Excel. The invoice detail
worksheet comes from an imported text file and can contain >10K rows.
Any thoughts?
level.
VEND_CODE | INV_NUMBER | INV_DATE | LINE_AMOUNT
123 123-A 3/5/08 100.00
123 123-A 3/5/08 200.00
456 456-B 3/31/08 500.00
456 456-B 3/31/08 800.00
456 456-C 4/2/08 700.00
I need to build a second worksheet that summarizes the amount by all
the other columns
VEND_CODE | INV_NUMBER | INV_DATE | INV_TOTAL
123 123-A 3/5/08 300.00
456 456-B 3/31/08 1300.00
456 456-C 4/2/08 700.00
This would be a simple select query with a group by clause in SQL, but
I'm at a loss as to how to accomplish it in Excel. The invoice detail
worksheet comes from an imported text file and can contain >10K rows.
Any thoughts?