Mimic SQL "group by"

Giganews Newsgroups
Subject: Mimic SQL "group by"
Posted by:  consultant_of_swing (jere.gree…@comcast.net)
Date: Fri, 25 Jul 2008

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?

Replies