array_diff in excel – finding missing values from column B that exist in column A

Fill column A with bigger sample space, aka the longer array.

Fill column B with smaller array, that has few or none of the elements from column A

Now, you need to find out values that are in column A but not in column B, here is what you do.
Create a separate column C and put this formula in cell C1 or $C$1


Ultimately your formula becomes match function dependable for whole column A. You just have to drag the cell C1 downwards.