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