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.