Question: how to find the difference between two columns in google sheets?
Answer: Open your Sheet on the page that you want to compare.
With data in columns A and B, highlight cell C1.
Paste '=if(A1=B1,“”,“Mismatch”)' into cell C1. ... 
Left-click on the bottom right corner of cell C1 and drag downwards.