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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
>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.
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" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>
Thanks for the feedback! I guessed you'd like it!!
Andy.
"Ana" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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.
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks