how to compare multiple rows in excel sheets?

user_18608932 0
Viewed 39

I have table values in sheet1

A1  B1      C1
Id  Name    Salary
100 James   1000
200 Nathan  2000    
300 Cook    4000
400 Lie     10000
500 umer    9899
600 barbi   2090

I have table values in sheet2

A1  B1      C1   
Id  Name    Salary
250 king    4000
100 James   1000
200 Nathan  2000    
300 Cook    4000
400 Lie     10000

I want to compare two sheets(1 and 2) and get the result in sheet3 like

A1  B1      C1
Id  Name    Salary
500 umer    9899
600 barbi   2090
excel-formula excel
1 Answers

With ms365, try:

enter image description here

Formula in I1:

=VSTACK(A1:C1,FILTER(A2:C7,COUNTIF(F2:F6,B2:B7)=0))

Obviously ditch the VSTACK() if not available and just use the FILTER() part.

user_97581940
Related