Home

Columns comparison in different tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-738389%22%20slang%3D%22en-US%22%3EColumns%20comparison%20in%20different%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738389%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20file%20with%20different%20tabs%20which%20contain%20information.%20I%20want%20to%20compare%20all%20C%20columns%20of%20the%20file%20for%20duplicates%20so%20that%20only%20common%20values%20remain.%20There%20might%20be%20the%20same%20name%20in%20C5%20of%20the%20first%20and%20C8%20of%20the%20second%20and%20C20%20of%20the%20third%20tab.%20How%20can%20I%20eliminate%20non%20common%20values%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738389%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738556%22%20slang%3D%22en-US%22%3ERe%3A%20Columns%20comparison%20in%20different%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738556%22%20slang%3D%22en-US%22%3EHighlight%20the%20column%20and%20click%20Remove%20Duplicates%20under%20the%20Data%20menu.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738566%22%20slang%3D%22en-US%22%3ERe%3A%20Columns%20comparison%20in%20different%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738566%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3ECan%20this%20be%20applied%20to%20all%20sheets%20within%20an%20excel%20workbook%3F%20I%20am%20aware%20of%20this%20as%20a%20single%20sheet%20command.%20I%20want%20to%20apply%20this%20in%20a%20number%20of%20sheets%20within%20my%20workbook%20and%20I%20am%20aiming%20for%20Excel%20to%20compare%20all%20values%20in%20all%20sheets%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20prompt%20response%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738579%22%20slang%3D%22en-US%22%3ERe%3A%20Columns%20comparison%20in%20different%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738579%22%20slang%3D%22en-US%22%3EFor%20that%2C%20you%E2%80%99ll%20need%20VBA%2C%20which%20is%20not%20my%20forte.%20I%E2%80%99m%20sure%20many%20experts%20here%20can%20provide%20you%20a%20solution%20for%20that.%3C%2FLINGO-BODY%3E
Dinos_Ipiotis
New Contributor

Hi there,

 

I have an excel file with different tabs which contain information. I want to compare all C columns of the file for duplicates so that only common values remain. There might be the same name in C5 of the first and C8 of the second and C20 of the third tab. How can I eliminate non common values? 

 

Thank you in advance

3 Replies
Highlight the column and click Remove Duplicates under the Data menu.

@TwifooCan this be applied to all sheets within an excel workbook? I am aware of this as a single sheet command. I want to apply this in a number of sheets within my workbook and I am aiming for Excel to compare all values in all sheets

 

Thank you for your prompt response

For that, you’ll need VBA, which is not my forte. I’m sure many experts here can provide you a solution for that.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies