Question: how to use excel to find difference between two columns?
Answer: Select the range of cells you want to compare. ... 
On the Home tab, go to Editing group, and click Find & Select > Go To Special… Then select Row differences and click the OK button.