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?
@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