Need to highlight matching rows (or) non matching rows

signup

New Member
Joined
Feb 15, 2018
Messages
12
Hi,

In my excel, i have two sheets.

  • in sheet1, i have three columns with almost 3000 rows.
  • in sheet2, i have two columns with 230 rows.

sheet2 was like a child sheet, all these data exists in sheet one. i need to exclude non matching data from sheet one.

the condition i have is, two columns in sheet2 should match with first two columns in sheet1.

Example: Sheet1
TableColumnData Type
EmpSalNumber(5)
EmpEmpNoNumber(4)
DeptLocChar(10)
SalGradeEnameChar(20)
AccountIdNumber(5)

<tbody>
</tbody>
Sheet2:

TableColumn
EmpSal
DeptLoc

<tbody>
</tbody>



If both Table_Name and column_name from sheet2 is equal to table_name and column_name from sheet1 then it was a perfect ma.
i.e. Sheet2(Table_name.Column_Name) = Sheet1(Table_Name.Column_Name)

finally i need non matching data..

Required Output is:

Sheet2:

TableColumnData Type
EmpEmpNoNumber(4)
SalGradeEnameChar(20)
AccountIdNumber(5)

<tbody>
</tbody>






please help me with this.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,095,404
Messages
5,444,265
Members
405,278
Latest member
Rashford

This Week's Hot Topics

Top