SOLVED

Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1449131%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449131%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20formula%20or%20anything%20else.%3C%2FP%3E%3CP%3EHere%20is%20the%20problem%20%3B%3C%2FP%3E%3CP%3EI%20am%20checking%20a%20translation%20and%20will%20be%20paid%20for%20each%20cell%20I%20have%20corrected%20and%20localised.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20corrected%20ones%20in%20the%20F%20column%20and%20old%20ones%20in%20the%20E%20column.%3C%2FP%3E%3CP%3EEach%20sentences%20are%20side%20by%20side.%3C%2FP%3E%3CP%3EPlease%20give%20me%20a%20hand.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1449131%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449184%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449184%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9n3bqzXIIuo%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9n3bqzXIIuo%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449189%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449189%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F693059%22%20target%3D%22_blank%22%3E%40Ahmadashry%3C%2FA%3E%26nbsp%3B%2C%20even%20though%20I%20can't%20watch%20the%20video%20right%20now.%20I%20have%20ended%20up%20solving%20my%20problem%20myself.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need a formula or anything else.

Here is the problem ;

I am checking a translation and will be paid for each cell I have corrected and localised. 

I have the corrected ones in the F column and old ones in the E column.

Each sentences are side by side.

Please give me a hand.

2 Replies
Highlighted
Best Response confirmed by sametbirol (New Contributor)
Highlighted

Thank you @Ahmadashry , even though I can't watch the video right now. I have ended up solving my problem myself.