List: Grouping

I have a monthly spreadsheet exported from an sql database, listing invoice details.
Each row represents one line from an invoice my problem is I need to group the rows by invoice number, however there are 2 added complications, firstly, there is a second column that needs grouping and a column which when grouped needs to be totalled e.g
A B C D

0035 12345 10 0
0035 12345 89 17.50
0001 12345 1 0

The above example is all 1 invoice number 12345, below is how the end result should look, grouping by B and then A, totalling the grouped columns of C and D

0035 12345 99 17.50
0001 12345 1 0
HELLLLLLLLLLLLLP!!!!!!!!!!!!!

It looks like either Data|Subtotals or data|pivottable would come very close to
what you want.

"stuart.young" wrote:
>
> I have a monthly spreadsheet exported from an sql database, listing
> invoice details.
> Each row represents one line from an invoice my problem is I need to
> group the rows by invoice number, however there are 2 added
> complications, firstly, there is a second column that needs grouping
> and a column which when grouped needs to be totalled e.g
> A B C D
>
> 0035 12345 10 0
> 0035 12345 89 17.50
> 0001 12345 1 0
>
> The above example is all 1 invoice number 12345, below is how the end
> result should look, grouping by B and then A, totalling the grouped
> columns of C and D
>
> 0035 12345 99 17.50
> 0001 12345 1 0
> HELLLLLLLLLLLLLP!!!!!!!!!!!!!
>
> --
> stuart.young
> ------------------------------------------------------------------------
> stuart.young's Profile: http://www.excelforum.com/member.php...o&userid=25765
> View this thread: http://www.excelforum.com/showthread...hreadid=391741

--

Dave Peterson