Home

find and display only matching values from two separate columns

%3CLINGO-SUB%20id%3D%22lingo-sub-815410%22%20slang%3D%22en-US%22%3Efind%20and%20display%20only%20matching%20values%20from%20two%20separate%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815410%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20columns%20(18%2C000%20rows%20in%20one%20and%2034%2C000%20in%20the%20other).%26nbsp%3B%20I'm%20trying%20to%20look%20into%20each%20separate%20column%20and%20display%20the%20matches%20in%20a%20new%20column.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815443%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20display%20only%20matching%20values%20from%20two%20separate%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815443%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396069%22%20target%3D%22_blank%22%3E%40alan_aldous%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20a%20few%20online%20tools%26nbsp%3B%3C%2FP%3E%3CP%3ETake%20a%20look%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Fexcel-online-addins.php%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Fexcel-online-addins.php%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815447%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20display%20only%20matching%20values%20from%20two%20separate%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815447%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Fexcel-online%2Fduplicate-remover%2Findex.php%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Fexcel-online%2Fduplicate-remover%2Findex.php%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815908%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20display%20only%20matching%20values%20from%20two%20separate%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396072%22%20target%3D%22_blank%22%3E%40hsedidin%3C%2FA%3Ethank%20you%20very%20much.%26nbsp%3B%20I%20found%20Able%20Bits%20to%20be%20very%20very%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
alan_aldous
New Contributor

I have two columns (18,000 rows in one and 34,000 in the other).  I'm trying to look into each separate column and display the matches in a new column.  

3 Replies

@Deletedthank you very much.  I found Able Bits to be very very helpful.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies