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
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies