The data
I need a formula to find out if column 1 has a pair in column 2.
The aim is to find the value that does not have a pair.
I have 4,333 rows of data and doing it manually would take me hours.
I tried
=VLOOKUP(A2,$B$2:$B$5,1,0)
but somehow it did not work... :(
The best formula helps you is a single-cell formula
[C1]=XMATCH(A1:Axxxxx,B1:Byyyyy)
where xxxxx - the last row in A
, yyyyy - the last row in B
.
In this solution, for each element in the first column, XMATCH displays the matched element from the second column or #N/A
if no match found.