Hi,
I need to find the 5 unique records highlighted in red below, based on the 2 data sets (left and right).
I've tried to use the unique tool, but that only compares each dataset separately. How can i crosscheck both data sets and split the output into 10 duplicate records, and 5 unique records.
This dataset is simplified from a larger dataset.
| ID | Name | Birthday | Total | | ID | Name | Birthday | Total |
| 19850 | John Smith | 1/1/2020 | 10 | | 19850 | John Smith | 1/1/2020 | 10 |
| 19851 | James Green | 1/2/2020 | 20 | | 19851 | James Green | 1/2/2020 | 20 |
| 19852 | Mary Doe | 1/3/2020 | 30 | | 19852 | Mary Doe | 1/3/2020 | 30 |
| 19853 | Joseph White | 1/4/2020 | 40 | | 19853 | Joseph White | 1/4/2020 | 40 |
| 19854 | Alex Brown | 1/5/2020 | 50 | | 19854 | Alex Brown | 1/5/2020 | 50 |
| 19855 | Amanda Williams | 1/6/2020 | 60 | | 19855 | Amanda Williams | 1/6/2020 | 60 |
| 19856 | Megan Jones | 1/7/2020 | 70 | | 19856 | Megan Jones | 1/7/2020 | 70 |
| 19857 | Crystal Blue | 1/8/2020 | 80 | | 19857 | Crystal Blue | 1/8/2020 | 80 |
| 19858 | Katie Gray | 1/9/2020 | 90 | | 19858 | Katie Gray | 1/9/2020 | 90 |
| 19859 | Nick Robert | 1/10/2020 | 100 | | 19859 | Nick Robert | 1/10/2020 | 100 |
| 19860 | Jason Adams | 1/11/2020 | 110 | | | | | |
| 19861 | Kevin Wright | 1/12/2020 | 120 | | | | | |
| 19862 | Vanessa Leonard | 1/13/2020 | 130 | | | | | |
| 19863 | Lisa Roosevelt | 1/14/2020 | 140 | | | | | |
| 19864 | Paul Washington | 1/15/2020 | 150 | | | | | |
