Dear all,
I have about 1000 columns with different length in the excel file; please kindly find the attached short example. I would like to compare the first column with the rest of columns and find identical items between the first column and column 2, between the first column and column 3, and so on; finally, print the identical items at the end of each column and the last row in the excel file as I show in the example file in red color.
Please kindly note that, in this file, the header name of columns, except for the first column is identical with the contents within the first column; this identical name between each column and its header name should be ignored when searching for identical items. For example, in the attached example, there are 7 columns; I would like to compare the column 1 with each of 6 columns. As you see, the header name of these 6 columns (A, B, C, D, E, F) is identical with the names in the column 1. So when, column 1 compare with column 2, A should be ignored (because it is identical to the header name of column 2) and B and F should be considered as the identical item between column 1 and column 2, and printed (as B,F) , and so on for other columns.
Your help would be highly appreciated in advance.
All the best
Bookmarks