Have 2 Tables. One on Sheet1 and Sheet2
Some people may appear in a Table but not in the other that's fine. What I need is to Filter and Just show where a person appears in both Tables but there Salary is different in one of the Tables
e.g. in Eg Below Result should be
Alan because he is 24000 in Table 1 and 24500 in Table 2 and Mike as he is 23550 in Table 1 but 23560 in Table 2
and would like result as below:-
Name Salary1 Salary2
Alan 24000 24500
Mike 23550 23560
Sheet1 Table
Sheet2 Table
Some people may appear in a Table but not in the other that's fine. What I need is to Filter and Just show where a person appears in both Tables but there Salary is different in one of the Tables
e.g. in Eg Below Result should be
Alan because he is 24000 in Table 1 and 24500 in Table 2 and Mike as he is 23550 in Table 1 but 23560 in Table 2
and would like result as below:-
Name Salary1 Salary2
Alan 24000 24500
Mike 23550 23560
Sheet1 Table
Name | Random Stuff | Random Stuff | Random Stuff | Salary |
Fred | x | x | x | 20250 |
Bob | x | x | x | 30000 |
Alan | x | x | x | 24000 |
Dave | x | x | x | 27000 |
Gemma | x | x | x | 26000 |
Mike | x | x | x | 23550 |
Ben | x | x | x | 28750 |
Arthur | x | x | x | 54500 |
Sheet2 Table
Name | Random Stuff | Random Stuff | Random Stuff | Salary |
Fred | x | x | x | 20250 |
Bob | x | x | x | 30000 |
Alan | x | x | x | 24500 |
Dave | x | x | x | 27000 |
Gemma | x | x | x | 26000 |
Mike | x | x | x | 23560 |
Ben | x | x | x | 28750 |
Mary | x | x | x | 32400 |