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 wrote:
> 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

[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

"Stopher" <[email protected]> wrote in message
news:[email protected]...
> 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 wrote:
>> 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
>