Columns Counting Function Reqd

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debby Bunce - 19 Aug 2006 01:38 GMT

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

Reply to this Message

Ron Coderre - 19 Aug 2006 02:45 GMT

It seems like a pivot table would be well suited to your situation:

First, make sure you have column headings (example: Name, Amount) in Cells
A1 and B1

<Data><Pivot Table>
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the Name field here
DATA: Drag the Amount field here
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each Name and the Sum of Amount.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Hello Fellow Excel users,
>
[quoted text clipped - 37 lines]
>
> Steve

Reply to this Message

Debby Bunce - 19 Aug 2006 14:32 GMT

spot thansk 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 egland and
this has help very substancially

thanks alot again

cheers

steve

> It seems like a pivot table would be well suited to your situation:
>
[quoted text clipped - 63 lines]
>>
>> Steve

Reply to this Message