Comparing two columns

[RonnyD]

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

[#2]

@RonnyD 

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)

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

https://support.microsoft.com/en-us/office/how-to-compare-data-in-two-columns-to-find-duplicates-in-...

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@NikolinoDE Thank you.

[#4]

Your welcome
I was happy to help you.

Nikolino
I know I don't know anything (Socrates)