2 columns with duplicate names and total numbers
 

I have 2 columns, one with duplicate names and another with different totals
numbers.
How can I get the total numbers for the one name.

2 columns with duplicate names and total numbers
 

Hi

You could use a pivot table. Really easy and superb!! Here is an intro:
http://peltiertech.com/Excel/Pivots/pivottables.htm

Hope this helps.
Andy.


"Ana" wrote in message
...
I have 2 columns, one with duplicate names and another with different
totals
numbers.
How can I get the total numbers for the one name.

2 columns with duplicate names and total numbers
 

Andy, I heard about Pivot Tables but never tried them, it worked wonderful,
you are great, Thank you.

"Andy" wrote:

Hi

You could use a pivot table. Really easy and superb!! Here is an intro:
http://peltiertech.com/Excel/Pivots/pivottables.htm

Hope this helps.
Andy.


"Ana" wrote in message
...
I have 2 columns, one with duplicate names and another with different
totals
numbers.
How can I get the total numbers for the one name.

2 columns with duplicate names and total numbers
 

Thanks for the feedback! I guessed you'd like it!!

Andy.

"Ana" wrote in message
...
Andy, I heard about Pivot Tables but never tried them, it worked
wonderful,
you are great, Thank you.

"Andy" wrote:

Hi

You could use a pivot table. Really easy and superb!! Here is an intro:
http://peltiertech.com/Excel/Pivots/pivottables.htm

Hope this helps.
Andy.


"Ana" wrote in message
...
I have 2 columns, one with duplicate names and another with different
totals
numbers.
How can I get the total numbers for the one name.