compare 2 columns

  1. W

    Compare Rows via VBA Loop

    I have a simple macro that I recorded and then edited in VB. But, I would like to turn this into a loop so I do not have to make over a 1000 entries just to compare the remaining rows. What I need it to do is compare rows 2:3, 4:5, 6:7, so and so on to highlight the differences in the columns...
  2. S

    compare two columns and copy matched data

    I have two workbooks, TheList.xls and Thedata.xls. I wish to compare Column B value in first workbook with column B value in second and whereever they match, copy data from column O to P of second workbook to corresponding row of first workbook at the same location, i.e. column O to P. Both...
  3. T

    Data validation - comparing two columns of data

    Excel version 2007 - I comparing two files of employee benefit data, one from my HRMS and one from the benefit provider. I want to compare the employee contribution columns from both of the files to ensure they match. I would like those that do not match to be highlight or flagged somehow so I...
  4. V

    Compare 2 columns and remove duplicates

    Hello, I have 2 columns A and B column A has about 700 rows and column B has about 400 rows. Some of the data appears in both column A and B so what i want to do is take any of the data that are not duplicates and move them to column C, the data in the 2 fields does not directly match up from...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top