VBA Program to Compare 4 Columns in Excel (Required)

[vijaysram]

Hi vijaysram, welcome to Excel Fox community

So what will be the comparison? Is it just a simple equating of values, like, if A1=B1=C1=D1, then True, else False?

Hi Exelfox, Thanks for your Interest in assisting me. I have 8 columns of Data having maximum of 2500 rows in each column. My requirement is :

1) If I run the macro, it should ask me for the input of Column names to be compared and also should ask for the column where it need to put the result with the column heading as result.

2) The result which i expected on the result column is the common duplicate values found on all the 4 columns.


I tried the above concept before posting this question on this forum but my excel got hang when i started running using above concept. Somewhere i am missing when i am converting the concept into a program. Can you please help me how to program the above concept..