if A2 = B2 then add 'Y' in C2 ... ?

[syncguy]

I'm trying to figure out a formula to rule-out errors/typos by comparing two columns that should have identical contents. This is my idea:
if A2 = B2 then add 'Y' in C2 ... then I'll filter or sort on Column C. The rows without a 'Y' will be the ones with the typos.
Any ideas on a formula would be very much appreciated.
much thanks!

[mohan.r1980]

i am not getting your problem
pls upload sample file for clearance

[johnjohns]

Just type A2=B2 in column C2 and drag down. Then filter for all the 'False'

[humacdeep]

Hello Sync,

Try this in C2 & copy down.

Please Login or Register  to view this content.

Regards,
Humac

[syncguy]

Both of those suggestions worked ! Thanks you guys !