detecting

  1. V

    Detecting "errors" in formulas

    Hi everyone, sorry for language misstakes first, but i'll try to do my best to elaborate problem. I have some problem with detecting "errors" in formulas. I have table with simple formula, example, in cell F6 is "=ROUND(D6*E6;2)". How can i check that in that cell F6 are exactly D6 and E6, or...
  2. C

    Detecting Changes in a Column for a Given ID

    Hi all. So I have a list of Employee IDs in column A and Dates in Column B. How would I go about writing a formula to tell me when a date is unique for a given ID. For example. Employee ID 1091 has 5 dates associated with it in Column B, but only 2 are unique, how would I go about calling out...
  3. C

    How to determine if an .xls file contains VBA Code

    Hi, I have several hundred spreadsheets to go through and detect wether it contains VBA code. I have the complete path of each file in a cell, is there a way to detect if the file contains vba code, without opening each file individually? Your help is greatly appreciated!

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