isblank invisible data

  1. 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...
  2. 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...
  3. 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...
  4. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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