EXCEL: Create new lists of data that contains both (A and B), only A, and only B

 Both

=FILTER(A2:A1019,ISNUMBER(XMATCH(A2:A1019,B2:B1119,0)))

Only A

=FILTER(A2:A1019,ISNA(XMATCH(A2:A1019,B2:B1119,0)))

Only B

=FILTER(B2:B1119,ISNA(XMATCH(B2:B1119,A2:A1019,0)))

Setup

1. Column A includes the data for Table A with a header

2. Column B includes the data for Table B with a header

3. User equation for "Both" in Cell C2

4. User equation for "Only A" in Cell D2

5. User equation for "Only B" in Cell E2

6. Modify data size