Question: how to find difference of two columns in excel sheet?
Answer: On the Home tab, go to Editing group, and click Find & Select > Go To Special… Then select Row differences and click the OK button. The cells whose values are different from the comparison cell in each row are highlighted.