miss

  1. L

    Sum Product and Blanks

    Hi there, I have the below formula, but i am wanting it to return "true" if the searched cell is also blank, but i cannot seem to get the formula right. So if cell D5 contains, Near Miss, Incident or a blank cell= true =SUMPRODUCT(--ISNUMBER(SEARCH({"Near Miss","Incident"},D5)))>0 Any...
    • Legacy 380435
    • Thread
    • blank cell formula miss true
    • Replies: 2
    • Forum: Excel Questions
  2. John Caines

    shorten formula if possible

    Hello All; I have a formula for a cell that will show the number of entries in the mentioned cells. Formula is...
  3. M

    Assistance required

    Hi all I am into horseracing and download results via a program which someone did for me, the thing I would like assistance with, is when the names get downloaded they are have in brackets following the name the country where the horse is bred.,but when I do a search it can miss some because of...
  4. E

    Calculations using Pivot Table data...

    I'm a reasonably new user of Pivot Tables, but appear to have stumped other experts at work with this problem. I have the following sample data in the first three columns and the Pivot Table to the right of it as follows...
  5. P

    Need some help!

    I'm struggling and need help to do the following: I'm pulling text, which can vary depending on the original result, from one sheet to another. This will show in cells E5:E24 and F5:F24 (not merged). For example, after one review E5 could say "Building" and F5 could say "Post 01.06.2004"...

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