Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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…

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

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