I'm looking for a formula that can do one of two things. Ultimately I don't care which one it does because I can make either of them work but if I had my preference I would prefer something like Solution 1.
I have two worksheets (let's call them SheetA and SheetB) each with the same headers, First, Last Cell, Email and Street in row 1 columns A-E
Solution 1:
I would like something that I can place the formula in A2, B2, C2, D2 and E2 on SheetC, that will look in Columns C, D and E rows 1-5000 on SheetA and compare it to Columns C, D and E rows 1-5000 on SheetB and return the nth unique row from SheetA where C, D and E on SheetA can't be found in C, D and E on SheetB. C, D and E would have to all 3 be found on the same row on SheetB, otherwise if just C and D were found but E didn't match, it would still recognize that as a unique row on SheetA and be pulled into Sheet C.
For Instance:
SheetA
SheetB
SheetC
Solution 2:
The alternative would be a formula that does the exact same thing but just looks at one Column, say for instance Column C, instead of looking at all 3 Columns C, D and E at the same time.
I have two worksheets (let's call them SheetA and SheetB) each with the same headers, First, Last Cell, Email and Street in row 1 columns A-E
Solution 1:
I would like something that I can place the formula in A2, B2, C2, D2 and E2 on SheetC, that will look in Columns C, D and E rows 1-5000 on SheetA and compare it to Columns C, D and E rows 1-5000 on SheetB and return the nth unique row from SheetA where C, D and E on SheetA can't be found in C, D and E on SheetB. C, D and E would have to all 3 be found on the same row on SheetB, otherwise if just C and D were found but E didn't match, it would still recognize that as a unique row on SheetA and be pulled into Sheet C.
For Instance:
SheetA
| First | Last | Cell | Street | |
| Greg | Pearson | 444-123-4567 | greg@fake.com | 123 Fake Pl |
| Chris | Smith | 444-456-4568 | chris@fake.com | 467 Lost Cir |
| Jeff | Toler | 444-982-4569 | jeff@fake.com | 4591 Orlando Rd |
| Jason | Cassidy | 444-734-4570 | jason@fake.com | 13456 Bike St |
| Dan | Foster | 444-467-4571 | dan@fake.com | 1242 Found Pl |
SheetB
| First | Last | Cell | Street | |
| Greg | Pearson | 444-123-4567 | greg@fake.com | 123 Fake Pl |
| Jeff | Toler | 444-982-4569 | jeff@fake.com | 4591 Orlando Rd |
| Dan | Foster | 444-467-4571 | dan@fake.com | 1242 Found Pl |
SheetC
| First | Last | Cell | Street | |
| Chris | Smith | 444-456-4568 | chris@fake.com | 467 Lost Cir |
| Jason | Cassidy | 444-734-4570 | jason@fake.com | 13456 Bike St |
Solution 2:
The alternative would be a formula that does the exact same thing but just looks at one Column, say for instance Column C, instead of looking at all 3 Columns C, D and E at the same time.
