+ Reply to Thread
Results 1 to 4 of 4

Combining duplicate records(rows)

  1. #1
    Jen
    Guest

    Combining duplicate records(rows)

    I'm pulling sales per item, but sometimes the item number shows up twice with
    two different sales numbers and I want to add the two sales numbers together
    and have that total sales under the one item number. Any ideas?

  2. #2
    Ken Wright
    Guest

    Re: Combining duplicate records(rows)

    Pivot table perhaps, or sort your data on item number and then use data /
    subtotals.

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :-)
    ----------------------------------------------------------------------------

    "Jen" <Jen@discussions.microsoft.com> wrote in message
    news:4F810F6D-9B0B-4F03-9694-6BAFEFD091C5@microsoft.com...
    > I'm pulling sales per item, but sometimes the item number shows up twice

    with
    > two different sales numbers and I want to add the two sales numbers

    together
    > and have that total sales under the one item number. Any ideas?




  3. #3
    Jen
    Guest

    Re: Combining duplicate records(rows)

    Isn't there a way to have excel analyze the data and combine the rows into
    one row when the item number is the same and then adding the sales number in
    both rows together?

    "Ken Wright" wrote:

    > Pivot table perhaps, or sort your data on item number and then use data /
    > subtotals.
    >
    > --
    > Regards
    > Ken....................... Microsoft MVP - Excel
    > Sys Spec - Win XP Pro / XL 97/00/02/03
    >
    > ----------------------------------------------------------------------------
    > It's easier to beg forgiveness than ask permission :-)
    > ----------------------------------------------------------------------------
    >
    > "Jen" <Jen@discussions.microsoft.com> wrote in message
    > news:4F810F6D-9B0B-4F03-9694-6BAFEFD091C5@microsoft.com...
    > > I'm pulling sales per item, but sometimes the item number shows up twice

    > with
    > > two different sales numbers and I want to add the two sales numbers

    > together
    > > and have that total sales under the one item number. Any ideas?

    >
    >
    >


  4. #4
    Ken Wright
    Guest

    Re: Combining duplicate records(rows)

    Yes, via a Pivot table or Data / Subtotals. Use either one to get what you
    want and then if you really want to lose the detail data, just copy and
    paste special the table as values. Then delete the detail data.

    Failing that you need to use VBA to do what you want, though it would
    probably be quickest to have the VBA use a pivot table or data Subtotals and
    then give you a hardcoded output table and deleting the detail.

    A pivot table giving you what you want can probably be created from your
    data in literally 60 seconds - Likewise Data / Subtotals

    Pivot table intro
    http://peltiertech.com/Excel/Pivots/pivotstart.htm

    Data / Subtotals:-
    Sort all your data on the item number, select all the data, do Data /
    Subtotals - At each change in 'Iten Number', Sum - Tick all the fields you
    want to sum.

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :-)
    ----------------------------------------------------------------------------

    "Jen" <Jen@discussions.microsoft.com> wrote in message
    news:DF307ECE-8ED3-4153-86CD-B59B5CEA69B2@microsoft.com...
    > Isn't there a way to have excel analyze the data and combine the rows into
    > one row when the item number is the same and then adding the sales number

    in
    > both rows together?
    >
    > "Ken Wright" wrote:
    >
    > > Pivot table perhaps, or sort your data on item number and then use data

    /
    > > subtotals.
    > >
    > > --
    > > Regards
    > > Ken....................... Microsoft MVP - Excel
    > > Sys Spec - Win XP Pro / XL 97/00/02/03
    > >

    >
    > --------------------------------------------------------------------------

    --
    > > It's easier to beg forgiveness than ask permission :-)

    >
    > --------------------------------------------------------------------------

    --
    > >
    > > "Jen" <Jen@discussions.microsoft.com> wrote in message
    > > news:4F810F6D-9B0B-4F03-9694-6BAFEFD091C5@microsoft.com...
    > > > I'm pulling sales per item, but sometimes the item number shows up

    twice
    > > with
    > > > two different sales numbers and I want to add the two sales numbers

    > > together
    > > > and have that total sales under the one item number. Any ideas?

    > >
    > >
    > >




+ 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