Announcement

Collapse
No announcement yet.

Combine Duplicate Rows

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Combine Duplicate Rows



    I have a document with duplicates entries, and was wondering how I could combine duplicates

    ie, I have:
    Colom A, Colom b
    bob, 10
    lisa, 5
    bob, 6
    lisa, 2
    mark, 4
    mark, 1
    bob, 2

    I want:
    Colom A, Colom b
    bob, 18
    lisa, 7
    mark, 5

    Any suggestions? Is there a built in tool?

  • #2
    Re: Combine Duplicate Rows

    Use a PivotTable If unsure, attach an example.

    Comment


    • #3
      Re: Combine Duplicate Rows

      Hi NO,

      Run 'Mac' ros on your OS?
      Cheers,

      dr

      "Questions, help and advice for free, small projects by donation. large projects by quote"

      http://www.ExcelVBA.joellerabu.com

      Comment


      • #4


        Re: Combine Duplicate Rows

        Originally posted by negativeOne View Post
        Is there a built in tool?
        Pivot table for the win. In fact, its a perfect project for you to get used to Pivot Tables if you havent used them before. Use the Pivot wizard.

        Ger
        Check out our new reputation system. Click on the Like button under the post!
        _______________________________________________

        There are 10 types of people in the world. Those that understand Binary and those that dont.

        Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

        The BEST Lookup function of all time

        Dynamic Named Ranges are your bestest friend

        _______________________________________________

        Comment

        Working...
        X