Columns Problem

[Debby Bunce]

Hello Fellow Excel users,

I have alittle problem which i hope somebody can point me in the right
direction

Picture my screen in excel

Col A is a list of Names with Multiple entries for the same person

Col B is a number ranging from 0 to 7

eg

A B

Joe Bloggs 1
Jim Smith 2
Joe Bloggs 4
Pete Smith 5
Jim Smith 4


What i want to create is another list where

Col A is a list of names Just 1 entry per name
Col B the sum of all entries for that persons name


eg

A B

Joe Bloggs 5
Jim Smith 6
Pete Smith 5


I hope ive explained it ok

if you have any questions just email me




Cheers


Steve

 

[Stopher]

Create a simpe pivot table with Column A "Name" and Column B "Score".

Drop the Name in the Fields section and Score in the "Data" section.

Stopher

 

[Debby Bunce]

spot thanks mate you have made a chap very happy

i simplfied my problem as column a and b have up to 60000 lines of data

im the results secretary of darts and dominoes league in grimsby england and
this has help very substancially

thanks alot again


cheers


steve