incorrect data

  1. A

    VBA: Automatically highlight cell when user enter data that does not match with another data from a different column

    Hello I am not a programmer so I apologize if my title seems confusing. This is what I meant: Cell D5 will automatically highlight as the data entered does not match with E4 for the same vehicle number. Cell D3 will not be highlighted as the data entered matched with E2 for the same vehicle...
  2. C

    Mismatched data between two tables and two fields

    I'm trying to get my head around how to find a situation where I might have a field where two tables match, but, where another field might not. I'll try and explain this the best I can. Table 1: <tbody> Lease ID Ticket Number 22045 100542 22046 100543 22047 100544 22048 100545...
  3. C

    Search Substring for data that shouldn't be on Spreadsheet

    Hi, I am trying to come up with an easy way in Excel 2010 to search column F for data that should not be there. Column F contains a string of data which contains a number. This number refers to the Job that has been undertaken, for Example A3 - 1G 123456 Data String. I know that the number...

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