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!

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top