miss

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...

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

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...

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...

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"...