A two column solution might be:
In column A, your number
In colunm B, their number
in column C
in column D
change the $34 to be how many rows you are comparing.
The isblank function is there to stop the comparison if the source cell is empty.