Excel 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

[Franz Verga]

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
>

Hi Steve,

first of all select your A column then from menu Data, Filter, Advanced
Filter, you can create a new list of unic entries in another location of
your sheet, then using the SUMIF function beside this new list of names you
can sum the values in your original list.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

[Epinn]

Hi,

Hope the following link helps.

Five ways to subtotal values in repeating data

http://office.microsoft.com/en-us/as...366211033.aspx

Cheers,

Epinn

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

thanks for the reply but ive created a pivot table and im sorted now

thanks again


steve


"Franz Verga" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>
> Hi Steve,
>
> first of all select your A column then from menu Data, Filter, Advanced
> Filter, you can create a new list of unic entries in another location of
> your sheet, then using the SUMIF function beside this new list of names
> you can sum the values in your original list.
>
>
> --
> (I'm not sure of names of menus, options and commands, because
> translating from the Italian version of Excel...)
>
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>

[Debby Bunce]

thanks for the reply and im using a pivot table and im all sorted now


thanks again


steve



"Epinn" <[email protected]_SPAM> wrote in message
news:%[email protected]...
> Hi,
>
> Hope the following link helps.
>
> Five ways to subtotal values in repeating data
>
> http://office.microsoft.com/en-us/as...366211033.aspx
>
> Cheers,
>
> Epinn
>
> "Debby Bunce" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>