Get common rows between two worksheets

 

By this feature, you can get common rows between worksheets.

 

 

Steps to go:

Step 1:Specify worksheet1. Clicking this line, the ‘Browse’ button appears on the right side. Clicking the button, you can select a workbook at first, and select a worksheet in it.

Step 2: Specify key column of worksheet1. The application will compare the two worksheets based on their key column.

Step 3: Specify worksheet2 in the same way as Step 1.

Step 4: Specify key column of worksheet2.

Step 5: Enter ‘Keep formulas in the result’. Normally you can select ‘No’.

Step 6: Click ‘Start’ button.

 

Example:

Let’s say you have customer list of year 2006 and 2005. Now you’d to find out which customers are in both lists.

 

The customer list of year 2006

User ID	User Name
97	Tom
52	Tony
63	Jack
24	John

 

The customer list of year 2005

User ID	User Name
32	Jack
52	Tony
24	John

 

Follow step 1~6:

Step 1: Specify worksheet1 as the customer list of year 2006.

Step 2: Key column of worksheet1 should be 1 here.

Step 3: Specify worksheet2 as the customer list of year 2005.

Step 4: Key column of worksheet2 is also 1.

Step 5: Click ‘Start’ button.

 

Result:

User ID	User Name
52	Tony
24	John

 

As you can see, Tony and John appear in both lists, these two customers are extracted into result.