Tag: excel
-
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…