Comparing two columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1788724%22%20slang%3D%22en-US%22%3EComparing%20two%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1788724%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I%20have%20two%20columns%20that%20I%20want%20to%20compare%20(well%20show%20the%20difference)%20as%20a%20pre%20and%20post%20test.%26nbsp%3B%20How%20do%20I%20do%20that%20to%20show%20the%20difference%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1788724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1788790%22%20slang%3D%22de-DE%22%3ESubject%3A%20Comparing%20two%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1788790%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835189%22%20target%3D%22_blank%22%3E%40RonnyD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22ocpCodeInline%20x-hidden-focus%22%3E%3DIF(ISERROR(MATCH(A1%2C%24C-1%3A%24C-5.0)%2C%22%22A1)%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-559893173%22%20id%3D%22toc-hId-559893173%22%20id%3D%22toc-hId-559893173%22%3EHow%20to%20compare%20data%20in%20two%20columns%20to%20find%20duplicates%20in%20Excel%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-compare-data-in-two-columns-to-find-duplicates-in-excel-fbeab47c-dd7a-4cf2-8aaf-50fc19d85dcc%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-compare-data-in-two-columns-to-find-duplicates-in-excel-fbeab47c-dd7a-4cf2-8aaf-50fc19d85dcc%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1788819%22%20slang%3D%22en-US%22%3EBetreff%3A%20Comparing%20two%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1788819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

3 Replies
Highlighted

@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.

 

Highlighted

@Nikolino Thank you.

 

 

Highlighted
Your welcome
I was happy to help you.

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