SOLVED with EXMERG #1: Selected issues from www.excelforum.com

Following problems were solved using app.exmerg.com

There’s no need to register to use the tool, just press Esc to access the workspace (there are already sample files) .

Problem #1: Match part number then extract qty onto a different sheet

Original post: http://www.excelforum.com/excel-formulas-and-functions/1001975-match-part-number-then-extract-qty-onto-a-different-sheet.html

To solve the problem, you can use following steps:

      1. Drag&Drop your Excel files into browser
      2. Choose from menu Merging tables -> Add Drag & Drop merging table
      3. Drag&Drop “part number” columns from Sheet #1 and Sheet #2 into the rules area (rows will be automatically matched)
      4. Export matched rows into XLSX/XLS

Columns from both sheets will be included in the export.

Problem #2: Compare Data from Two Sheets and Extra the matching data with all the columns

Original post: http://www.excelforum.com/excel-formulas-and-functions/1001501-compare-data-from-two-sheets-and-extra-the-matching-data-with-all-the-columns.html

I would use following steps:

      1. Drag&Drop your Excel files into browser
      2. Choose from menu Merging tables -> Add Drag & Drop merging table
      3. Drag&Drop “ID” column from Sheet2 into the rules area (left side of the rule)
      4. Next Drag&Drop “ID” column from Sheet1 into the right side of the rule
      5. Export matched rows into XLSX/XLS

Columns from both sheets will be included in the export.

Problem #3: Find like numbers over two spreadsheets and highlight

Original post: http://www.excelforum.com/excel-formulas-and-functions/997110-find-like-numbers-over-two-spreadsheets-and-highlight.html

I would use following steps:

      1. Drag&Drop your Excel files into browser
      2. Choose from menu Merging tables -> Add Drag & Drop merging table
      3. Drag&Drop “column E” from Spreadsheet 1 into the rules area (left side of the rule)
      4. Next Drag&Drop “Column A” from Spreadsheet 2 into the right side of the rule
      5. Export matched rows into XLSX/XLS

Resulting spreadsheet will have 6+9 columns, and will contain row for each match between Column E of Spreadsheet 1 and Column A Spreadsheet 2.

Share this Post: Facebook Twitter Pinterest Google Plus StumbleUpon Reddit RSS Email

Leave a Comment