troubleshooting Question

Excel formula Question

Avatar of grantwatson
grantwatsonFlag for New Zealand asked on
Microsoft Excel
2 Comments2 Solutions226 ViewsLast Modified:
Hi,

I have two columns, one column of names and the other numbers like so...

Alan      43
Alan      33
Alan      0
Andrew      40
Andrew S      305
Andrew S      178
Andy      11
Andy      0
Andy      22
Brendon      216
Brendon      322
Brendon      144
Brendon      4
Brendon      65
Brian      168
Brian      18
Brian      83
Brian      26
Brian      111
Brian      108
Cameron      23
Cameron      41
Cameron      52
Cameron      19
Cameron      95
Cameron      34
Cameron      84
Cameron      13
Cameron      25
Cameron      225
Cameron      49
Cameron      128

What i want to be able to do is at the last entry of each name havea total of all the numbers assoicated with each name. so it would look like this... the figures change every month.

Alan      43            
Alan      33            
Alan      0            76
Andrew      40            40
Andrew S      305            
Andrew S      178            483
Andy      11            
Andy      0            
Andy      22            33
Brendon      216            
Brendon      322            
Brendon      144            
Brendon      4            
Brendon      65            751
Brian      168            
Brian      18            
Brian      83            
Brian      26            
Brian      111            
Brian      108            514
Cameron      23            
Cameron      41            
Cameron      52            
Cameron      19            
Cameron      95            
Cameron      34            
Cameron      84            
Cameron      13            
Cameron      25            
Cameron      225            
Cameron      49            
Cameron      128            788

thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros