isblank invisible data

  1. V

    How to get Total count in a column excluding Blank Cells in a formula..

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

    ISBLANK, IF formula help!

    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)...
  3. M

    Paste data into new file works, but not if formatted as table

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

    Problem with ISBLANK when there is a formula cell

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

    ISBLANK not working/malfunctioning

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

    Isblank function erroneous results

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

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