comparing 2 different columns and looking for missing numbers

[uiucfan1]

Column A is the listing of Applicants that went to the next stage of testing ... column B is a listing of applicants deemed ineligible. I'm trying to compare one to the other because the straight subtraction doesn't work. Is there a formula that I can use to determine if the numbers in column B are also in column A (and vice versa)? I've included a small set of numbers from my spreadsheet as an example. Thanks!

24-001	24-003
24-002	24-022
24-004	24-023
24-005	24-024
24-006	24-036
24-007	24-038
24-008	24-039
24-009	24-045
24-010	24-052
24-011	24-059
24-012	24-061
24-013	24-068
24-014	24-072
24-015	24-073
24-016	24-083
24-017	24-086
24-018	24-092
24-019	24-096
24-020	24-109
24-021	24-127
24-025	24-133
24-026	24-139

 

[Fluff]

This will show which values are in both columns

=FILTER(A2:A100,(ISNUMBER(XMATCH(A2:A100,B2:B100)))*(A2:A100<>""))

 

[uiucfan1]

That's it - I had one # that I couldn't figure out which one was on both lists.... and this found it. (out of 4,170 total cells) I'm extremely thankful for your help (and not having to manually do this one by one)

 

[Fluff]

You're welcome & thanks for the feedback.