isblank invisible data

Dear Friends, I need a little help on this. I have entered formula to make a cell return a value when the data is available on other cell. In the attached excel sheet, I have dates in column E. There are some cells where the date will not be available. I wrote a formula in column F...

Hi Experts of Mr Excel.com, Please let me know if I'm not making sense. Heres a sample. Action 1 - 4 will result in either a "Pass" or "Fail" Overall Outcome = Fail (If 70% or below, or if Action 3 results in a Fail) Overall Outcome = Pass (if above 70%, and if Action 3 results in a Pass)...

Hi everyone! So I have this database, wich I got from and =IFERROR (INDEX formula. I have 50 rows, and some of them have results, others not. When I copy this to another sheet and paste it as value, Excel sees the cells without result still as NOTBLANK. This changes when I double click on...

Hi again Today's problem involves lists and ISBLANK when i am trying to remove the blank cells. 1) I have a list over 3 columns, BV, BW and BX the lists go from Row3 to Row300. I have named BV3:BX300 as tab. Some have formulae in that produce text, others have a formula that produces a blank...

I'm going mad trying to figure out the issue. ISBLANK is returning FALSE for a seemingly blank cell. The formula is: ISBLANK(VLOOKUP($A13,data1,COLUMN(C:C),TRUE) I thought it has something to do with the VLOOKUP returned value. However,when I press delete on cell A13, the problem is fixed...

Using data of unknown origin in Excel I found Isblank was giving a FALSE result on some apparently blank cells while giving a TRUE result on others. Even if I used TRIM and CLEAN functions on the offending data and pasted the resulting values back the the original locations, the Isblank result...