+ Reply to Thread
Results 1 to 5 of 5

Merging data

  1. #1
    Registered User
    Join Date
    07-27-2009
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    Merging data

    Hi,

    I'm trying to search a list for names and add totaled data for new names to another list. However, I end up adding a new row for each time I find a name that doesn't match because if the name doesn't match a row it gets added, then it checks the next row for a match and will add it again if it's not the same. I know what the problem is, but I don't know how to fix it! Any help would be appreciated.

    NAdvisors is the number of rows already in the list I'm creating.
    NRows is the rows in the list I'm adding data from.

    Please Login or Register  to view this content.
    Last edited by sessy; 09-09-2009 at 08:02 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Merging data

    i'd put some code tags around that if i were you or a mod will come and bite you!
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging data

    And here one is: Sessy, please take a few minutes to read the forum rules, and then edit your post to add code tags.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    07-27-2009
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Merging data

    Sorry! It's fixed now.

  5. #5
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Merging data

    Please attach a workbook.

+ 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