throw

  1. R

    Matching Formula has me Stumped!

    I've been working on this one for a bit with no success. I've outlined what I'm trying to accomplish below: Currently, the return works very well, but only with exact matches, everything else throws me an ERROR. I tried modifying the match_type which causes me to throw an error for some reason...
  2. V

    Userform Data Validation

    Hello, I have a userfom with a large number of fields in it. Most but not all have some form of validation on the fields which turns the background colour red if an illegal value is entered e.g. invalid dates etc. I need to find a way that to throw up an error message if the user clicks submit...
  3. TresRing

    Need VBA for IF cell filled AND other cell blank then throw ERROR pop up

    I looked through past questions but did not find a question or solution that completely matched what I need. I need a macro that will throw an error IF any cell in column B is populated AND any other cell in that row is blank. It can't be coded into the cell directly because the data will be...
  4. B

    Dara Cleansing

    Does anybody have any tips for large data set cleansing in excel. I work with data that originates from many different places like data warehouses, webpages, various applications. A lot of clutter comes along with it like non printable characters, spaces, html, unicode and many other things that...

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