If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel formula help - add / sort / groups

Random · 2008-11-24 23:03:50

I have an excel spreadsheet. It contains the following:sue 5 john 6 paddy 7 mary 5 john 6 john 9 paddy 5 sue 8 betty 3 mary 2 betty 5 The names are in one column and the numbers are in the one next to it basically. What I could like to do is group them together (I can do this with sort) and I'd like to total each group. So…

Options

25-11-2008 12:03am

#1
Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669
I have an excel spreadsheet. It contains the following:
sue 5 john 6 paddy 7 mary 5 john 6 john 9 paddy 5 sue 8 betty 3 mary 2 betty 5

The names are in one column and the numbers are in the one next to it basically.

What I could like to do is group them together (I can do this with sort) and I'd like to total each group.

So I'd like to be left with this:
Who Number Total betty 3 betty 5 8 john 6 john 6 john 9 21 mary 5 mary 2 7 paddy 7 paddy 5 12 sue 5 sue 8 13

I have about 3000 rows that I need to do this on.

Thanks

0

Comments

Options
#2 25-11-2008 1:43am
Random

Closed Accounts Posts: 19,080 ✭✭✭✭

Join Date: September 2004

Posts: 16669

Pivottables. That's the solution if anyone else has a similiar problem. Didn't even know the bloody things existed. Man they're useful !

0