Microsoft Excel is a widely used programme which simplifies all manual calculations using columns. The presence of multiple numerical values when comparing columns can make calculations tedious. This article will highlight and solve the query of comparing the values of two Microsoft Excel sheet columns. Finding values in column A but not in column B can be carried out by matching column A's value with B, assuming the values start from the 2nd column. The result of the below syntax will appear in another column, say column C.