non-matching data

  1. T

    How to list and compare locations of non-matches in other sheets?

    Hi everyone, I need a VBA code that can compare a master list to lists in other sheets (could be an unlimited amount of sheets), and highlight the locations of the the non-matches and take the users to those locations. For example, if on the master list it says apple, and on sheet 2 column a it...
  2. B

    VBA: Looping to check for non-matches then appending to a list when record not matched

    Hello, I have two sheets in which I am trying to append records from one to the other. The main list is ws2 and the second list, ws5, is the one to be populated with records from ws2 by appending record i to the last row in the list. Records are only to be appended where they do not exist in...
  3. Dr. Demento

    Non-matching to named range - CF not working as advertised

    I am attempting to highlight any single letter value that is not listed in a named range, as a form of visual data validation. I have a list of single letters in col K that go from A-Z but I'm only interested in four of them (C|L|U|M), which I've named as a range. Since I apply this to all of...
  4. A

    Identifying and highlighting non-matching text across 2 columns

    Hope you can help a first time poster (self taught at Excel). I am working in Excel 2007 and have data in 2 columns (approx. 70000 rows) which contains details of 500 current & historical: Employee No., Role, Name & Office I have cleansed, trimmed and matched so I know which rows do not match...

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