Comparing two columns

Question

Hello I have two columns that I want to compare (well show the difference) as a pre and post test.&nbsp; How do I do that to show the difference?

nikolinode · Answer

RonnyD&nbsp;&nbsp;=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)How to compare data in two columns to find duplicates in Excelhttps://support.microsoft.com/en-us/office/how-to-compare-data-in-two-columns-to-find-duplicates-in-excel-fbeab47c-dd7a-4cf2-8aaf-50fc19d85dcc?ui=en-us&amp;rs=en-us&amp;ad=us&nbsp;I would be happy to know if I could help.&nbsp;NikolinoI know I don't know anything (Socrates)&nbsp;* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.&nbsp;

ronnyd · Answer

NikolinoDE&nbsp;Thank you.&nbsp;&nbsp;

nikolinode · Answer

Your welcomeI was happy to help you.NikolinoI know I don't know anything (Socrates)

Forum Discussion

Comparing two columns

3 Replies

How to compare data in two columns to find duplicates in Excel