+ Reply to Thread
Results 1 to 3 of 3

Merge two spreadsheets with data

  1. #1
    Registered User
    Join Date
    06-16-2017
    Location
    Germany
    MS-Off Ver
    XP
    Posts
    2

    Merge two spreadsheets with data

    Hello, I want to merge two different spreadsheets that share common row identifiers (alfa, beta, gama) and can be sorted by this identifier. Some of identifiers in one sheet are not present in another one. I want to end up with one sheet having only row identifiers that exist in both sheets and their corresponding values from both sheets. For an illustration:

    spreadsheet 1
    alfa 5467
    gama 2345
    beta 678

    spreadsheet 2
    beta 3244
    gama 798

    result:
    (no alfa here)
    beta 678 3244
    gama 2345 798

    Thanks.
    Last edited by privatne; 06-16-2017 at 04:45 AM.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Merge two spreadsheets with data

    Try in sheet2

    C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag down!!

    Result Sheet

    A1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    B1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Both Drag down!!

    Check attached file.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    06-16-2017
    Location
    Germany
    MS-Off Ver
    XP
    Posts
    2

    Re: Merge two spreadsheets with data

    Thank you for your reply. Can you write here what you see in the result sheet please?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merge Spreadsheets
    By MadDino in forum Excel General
    Replies: 1
    Last Post: 04-16-2016, 02:30 AM
  2. Replies: 1
    Last Post: 11-02-2012, 09:59 AM
  3. How to merge data from separate spreadsheets
    By Luck in forum Excel General
    Replies: 6
    Last Post: 04-17-2011, 06:38 PM
  4. Link Spreadsheets - Merge Data
    By Keeper4826 in forum Excel General
    Replies: 15
    Last Post: 11-07-2006, 02:42 PM
  5. [SOLVED] how do I merge data from separate spreadsheets
    By Gary Milks in forum Excel General
    Replies: 1
    Last Post: 06-27-2006, 07:55 AM
  6. Merge Data from Multiple Spreadsheets
    By Carm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2005, 10:06 AM
  7. [SOLVED] How do you merge two spreadsheets to update data.
    By Gerrysr in forum Excel General
    Replies: 1
    Last Post: 02-25-2005, 01:06 PM

Tags for this Thread

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