Jul 04 2019 07:16 AM
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
Jul 04 2019 08:14 AM
Jul 04 2019 08:25 AM - edited Jul 04 2019 08:26 AM
@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
Jul 04 2019 08:49 AM