Quick Excel Help Please?

[audi321]

Hi all. I have a sheet which in column A has client names and in Column B has a commission figure.

Problem is, most clients have multiple entries e.g.

Smith £100.00
Smith £150.00
Smith £200.00
Bloggs £75.00
Bloggs £160.00

Is there a way to automatically place a total at the end of each name and then sort it by this subtotal? e.g

Smith £100.00
Smith £150.00
Smith £200.00
Smith Total £450.00
Bloggs £75.00
Bloggs £160.00
Bloggs Total £235.00

Even better if I could automatically then 'hide' the individual rows and just leave the totals?

Thanks in advance!

[audi321]

It's Office 2003 so quite old. Just to add there's about 4000 rows with around 200 clients so each client has around 20 payments.

[audi321]

Cheers Slinky that's just what I wanted.

I've managed to get them split and a 'total' row put in, but how would I actually get it to total up the figure? At the moment it looks like

Smith £100
Smith £100
Smith £100
Smith total

ie. I can't work out how to get the figures to automatically add up?

[audi321]

slinky said:

So you have a sub total but you want a grand total?

I have no totals at all, just a space where they need to be, I think I've only done the pivot table and not the sum but I'm trying to work out where this goes

[audi321]

Liszt said:

You really don't need a pivot table!

Have a look at the link I posted.

Will show you how to do it to give this:

I'm not sure my version does this, as under 'Data' and 'Group and Outline' I do not have a Subtotal option? Although I must admit this does look easier than a pivot table

[audi321]

Ahhhh yes it was thank you. Don't suppose you know how to now filter it by the subtotal amounts?

[audi321]

Thanks all for your help, all sorted now