Column comparison

[newmohan]

Need help to Compare the columns in excel sheet.

I need to do the comparison in excel as shown below.

In sheet1, I have list of numbers in Columns from ( Column A to J)

I want to compare each column with all other columns to find out how many numbers it has similar with other columns.

Like wise I want to do it for all the columns.

It would be better if i got the result in the next sheet.

The results will be like

In sheet2

Column A Column B
10 % with columnB 10% with Column A
9% with column C 20% with Column C

[jeffreybrown]

I believe a small workbook with some sample data and expected results would help tremendously.

[kindm]

Hello.
Hope this helps.
This file compares the values ​​of each column and says that percentage is equal to another column.
However the file is quite heavy due to the formulas used and with a large amount of data will take some time to calculate.
Any questions just reply.

kindm,