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

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

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top