How to compare an entire column to multiple columns in Excel

P

paveernaa

I have an excel sheet with about 200 columns and about 3000 rows of
data. Some of the columns are repeated with same values. I need to
find out the duplicate

Could anyone of you can help me finding a formula that compares each
columns and identify the equal columns:

For example from the dataset given below, column A = Column C

as bc as bc
a1 e2 a1 e8
c8 c8 c8 c8
r8 t9 r8 r6

Thank you.

Regards,
PS
-
 
P

paveernaa

Thanks Peo. This solution works for Adjacent columns.

My issue is that the column A could match with multiple Columns; ie:
columns B, E,R,T,Z,AA, AZ...etc.

Same testing need to be verified against each of the columns from start
to the end, so that ultimately, all duplicate columns can be removed
from the spread sheet.

Thank you
Regards,
PS
 
Top