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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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…

24-11-2008 11:03pm

#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

#2 25-11-2008 12: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