vba match

  1. C

    VBA check range for matching rows

    Hi All I have some data that has been input into a system and i have the export from that system as well. I need to check if the data has been input correctly or not Workbook1 has that data that has been input into the system Workbook2 has the export. There are multiple tabs on each, but...
  2. N

    VBA date match by rounding

    Hi, I'm looking to pull a date (call it D1) from 1 tab, and look it up with the match function (yes, must be the match function because there are other criteria involved). Problem is, the date i am looking up can be Any day of the year, but the table i am looking it up in (call it D2), is only...
  3. P

    VBA Index match of dates

    I am trying to take a date from a Userform field and compare it to Column "A". If there is a match, I want the row number to the row where the match was found. For testing purposes these are the values in Column "A": <colgroup><col></colgroup><tbody> #2/26/2018# #2/25/2018# #2/21/2018#...

This Week's Hot Topics

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
Top