I am trying to make an assignment system for a project I'm doing. I have two google forms linked up to my spreadsheet, and thus I have three separate sheets: Start, Finish, and Sheet1. Sheet1 is where I want the active assignments to show, and Start and Finish are where the results from the google forms go. Each assignment has three columns: Username, item, and quantity. The specifics of an assignment that someone starts are in Start, and the specifics of an assignment that someone finishes are listed in Finish.
Let's say I have the following data in Start:
| Username | Item | Quantity |
|---|---|---|
| 12345 | Apple | 3 |
| 12345 | Apple | 3 |
| 54321 | Orange | 2 |
| 12345 | Orange | 4 |
And the following data in Finish:
| Username | Item | Quantity |
|---|---|---|
| 12345 | Apple | 3 |
| 12345 | Orange | 4 |
Then, I want Sheet1 to show the following:
| Username | Item | Quantity |
|---|---|---|
| 12345 | Apple | 3 |
| 54321 | Orange | 2 |
Basically, it takes pairs of matching rows and eliminates them. Then, it takes whatever remains in Start and shows them in Sheet1. Is there any function that I can put in Sheet1 that can do this?
