thanks!

  1. HeRoseInThree

    If formula, with a twist

    I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work. Any ideas?
  2. HeRoseInThree

    The first part of this formula works, but not the rest.

    The first 4 parts work, but none of the rest. Any ideas why? =IF(ISBLANK(A19),"",IF(A19="tow","Towing",IF(A19="etow","Emergency roadside towing",IF(A19="itow","In house towing",IF(A19="inspect","Inspect to determine necessary repairs",IF(A19=”dot”,"DOT re-inspection fee",IF(A19=”scene”,"Clean...
  3. HeRoseInThree

    I don't know what to call it. That's why I cant Google it : )

    First Name Last name Suffix Complete name Last, First Phone DOB Hire Term SSN Tenure Phone SSN Age john doe jr John Doe Jr Doe, John 8158675309 5/21/73 11/28/2017 123-45-6789 2 years, 11 months, 5 days (815) 867 - 5309 6789 47 If I enter a date in the term column (j2) is there a way to...
  4. C

    Help with Loop Without Do Error

    Hi guys, I've been trying to fix this VBA code (that a previous employee left us), but since I have no experience in VBA, I can't seem to figure it out. Would anyone of y'all be able to help me out? Sub categorization3a() Application.ScreenUpdating = False 'further segment PRODUCT row =...
  5. V

    Compilation error : BLOCK IF WITHOUT END IF

    If ((char = ",") And (cou >= 10)) Then add = add + char + vbNewLine c = 1 cou = 0 Else add = add + char c = 0...
  6. F

    Update existing hyperlinks automatically when changing the folder name linked documents are saved under

    Dear Forum members,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am desperately looking for some advice from you Excel experts!<o:p></o:p> At work we are using an excel spreadsheet as a project checklist during the project execution phase...
  7. S

    disabling the info / warning messages!!!

    hi, pls help me disabling the prompt msg that encounter during the macro is running for eg - sheet is protected etc. secondly I wanted to know if i am asking user to input a no. in a input box but if the user presses cancel button insead of pressing ok then their should not be any error. it...

Watch MrExcel Video

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