+ Reply to Thread
Results 1 to 4 of 4

2 columns with duplicate names and total numbers

  1. #1
    Ana
    Guest

    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. #2
    Guest

    Re: 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" <[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.




  3. #3
    Ana
    Guest

    Re: 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" <[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.

    >
    >
    >


  4. #4
    Guest

    Re: 2 columns with duplicate names and total numbers

    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.

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1