Get Digital Help
  • Home
  • Functions
    Compatibility Database Date & Time Engineering Financial Information Logical Lookup & Reference Math & Trigonometry Statistical Text Web
  • Formulas
    Basic formulas Advanced formulas
  • Features
    Excel defined table Advanced filter Data Validation Drop down lists Named ranges Solver
  • Charts
  • Conditional formatting
  • Pivot table
  • VBA
    VBA Functions Methods Properties Statements Macros User defined functions Files & folders
  • Archive
    Categories Products
  • Contact
    About me Blogs I read

    Excel functions

    Compatibility

    BETADIST function

    BETAINV function

    BINOMDIST

    CHIDIST function

    CHIINV function

    CHITEST function

    CONFIDENCE

    COVAR function

    CRITBINOM

    EXPONDIST

    FDIST function

    FLOOR function

    FORECAST function

    FTEST function

    GAMMADIST

    LOGNORMDIST

    MODE function

    RANK function

    STDEV function

    Database

    DAVERAGE function

    DCOUNT function

    DCOUNTA function

    DGET function

    DMAX function

    DMIN function

    DPRODUCT function

    DSTDEV function

    DSTDEVP function

    DSUM function

    DVARP function

    Date and Time

    DATE function

    DATEDIF function

    DATEVALUE

    DAY function

    DAYS function [2013]

    EDATE function

    EOMONTH function

    HOUR function

    MINUTE function

    MONTH function

    NETWORKDAYS

    NETWORKDAYS.INTL [2010]

    NOW function

    SECOND function

    TIME function

    TIMEVALUE

    TODAY function

    WEEKDAY function

    WEEKNUM function

    WORKDAY function

    YEAR function

    YEARFRAC function

    Engineering

    BIN2DEC function

    BIN2HEX function

    BIN2OCT function

    BITAND function [2013]

    BITLSHIFT [2013]

    BITOR function [2013]

    BITRSHIFT [2013]

    BITXOR function [2013]

    COMPLEX function

    CONVERT function

    DEC2BIN function

    DEC2HEX function

    DEC2OCT function

    DELTA function

    Financial

    ACCRINT function

    ACCRINTM function

    CUMIPMT function

    CUMPRINC function

    DB function

    DOLLARFR function

    EFFECT function

    FV function

    IPMT function

    ISPMT function

    NOMINAL function

    PDURATION

    PMT function

    PPMT function

    PRICEMAT function

    RATE function

    Information

    CELL function

    ERROR.TYPE

    INFO function

    ISBLANK function

    ISERR function

    ISERROR function

    ISFORMULA [2013]

    ISLOGICAL

    ISNA function

    ISNONTEXT

    ISNUMBER function

    ISODD function

    ISREF function

    ISTEXT function

    N function

    NA function

    SHEET function

    SHEETS function

    TYPE function

    Logical

    AND function

    FALSE function

    IF function

    IFERROR function [2007]

    IFNA function [2013]

    IFS function [Office 365]

    NOT function

    OR function

    SWITCH function [2016]

    TRUE function

    XOR function [2013]

    Lookup and reference

    ADDRESS function

    AREAS function

    CHOOSE function

    COLUMN function

    COLUMNS function

    FORMULATEXT [2013]

    HLOOKUP function

    HYPERLINK

    INDEX function

    INDIRECT function

    LOOKUP function

    MATCH function

    OFFSET function

    ROW function

    ROWS function

    TRANSPOSE

    VLOOKUP function

    Math and trigonometry

    ABS function

    ACOS function

    ACOSH function

    ACOT function [2013]

    ACOTH function [2013]

    AGGREGATE

    ASIN function

    ASINH function

    ATAN function

    ATAN2 function

    ATANH function

    BASE function

    CEILING function

    COMBIN function

    COMBINA function [2013]

    COS function

    COSH function

    COT function [2013]

    COTH function [2013]

    CSC function

    DECIMAL function [2013]

    DEGREES function

    EVEN function

    EXP function

    FACT function

    FACTDOUBLE

    FLOOR.MATH [2013]

    FLOOR.PRECISE [2010]

    GCD function

    INT function

    LCM function

    LN function

    LOG function

    LOG10 function

    MINVERSE function

    MMULT function

    MOD function

    MROUND function

    MULTINOMIAL

    MUNIT function [2013]

    PI function

    POWER function

    PRODUCT function

    QUOTIENT function

    RADIANS function

    RAND function

    RANDBETWEEN

    SEC function

    SECH function

    SERIESSUM

    SIGN function

    SIN function

    SINH function

    SQRT function

    SUBTOTAL function

    SUM function

    SUMIF function

    SUMIFS function [2007]

    SUMPRODUCT

    SUMSQ function

    SUMX2MY2 function

    SUMX2PY2 function

    SUMXMY2 function

    TAN function

    TANH function

    TRUNC function

    Statistical

    AVEDEV function

    AVERAGE function

    AVERAGEA function

    AVERAGEIF [2007]

    AVERAGEIFS [2007]

    BETA.DIST [2010]

    BETA.INV function [2010]

    BINOM.DIST [2010]

    BINOM.INV [2010]

    CHISQ.DIST

    CHISQ.DIST.RT [2010]

    CHISQ.INV [2010]

    CHISQ.INV.RT [2010]

    CHISQ.TEST [2010]

    CONFIDENCE.NORM [2010]

    CONFIDENCE.T [2010]

    CORREL function

    COUNT function

    COUNTA function

    COUNTBLANK

    COUNTIF function

    COUNTIFS function [2007]

    COVARIANCE.P [2010]

    COVARIANCE.S [2010]

    EXPON.DIST [2010]

    F.DIST function [2010]

    F.DIST.RT [2010]

    F.TEST function [2010]

    FORECAST.LINEAR [2016]

    FREQUENCY

    GAMMA function [2013]

    GAMMA.DIST [2010]

    GEOMEAN function

    GROWTH function

    INTERCEPT

    LARGE function

    LINEST function

    LOGEST function

    LOGNORM.DIST [2010]

    MAX function

    MAXIFS function [2016]

    MEDIAN function

    MIN function

    MINA function

    MINIFS function [2016]

    MODE.MULT [2010]

    MODE.SNGL [2010]

    NORM.DIST [2010]

    NORM.INV function [2010]

    PERMUT function

    PERMUTATIONA

    PHI function

    PROB function

    QUARTILE.INC [2010]

    RANK.AVG function [2010]

    RANK.EQ function [2010]

    SKEW function

    SLOPE function

    SMALL function

    STANDARDIZE

    STDEV.P function [2010]

    STDEV.S function [2010]

    STDEVA function

    STDEVPA function

    TREND function

    TRIMMEAN function

    VAR.P function [2010]

    VAR.S function [2010]

    Text

    ASC function

    CHAR function

    CLEAN function

    CODE function

    CONCAT function [Office 365]

    CONCATENATE

    EXACT function

    FIND function

    FIXED function

    LEFT function

    LEN function

    LOWER function

    MID function

    REPT function

    RIGHT function

    SEARCH function

    SUBSTITUTE

    T function

    TEXT function

    TEXTJOIN function [Office 365]

    TRIM function

    UPPER function

    VALUE function

    Web

    ENCODEURL [2013]

    WEBSERVICE [2013]




ISNONTEXT function


Excel » Functions » Information » ISNONTEXT function »

How to use the ISNONTEXT function

The ISNONTEXT function returns TRUE if value is not text, also returns TRUE if cell is empty. Formula in cell […]

Filter common text values in two different ranges

Array formula in B26: =INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)>0)*ISTEXT(tbl_1)*NOT(COUNTIF($B$25:B25, tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1)), MATCH(0, ISNONTEXT(INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)>0)*ISTEXT(tbl_1)*NOT(COUNTIF($B$25:B25, tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1)), , 1))+COUNTIF($B$25:B25, INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)>0)*ISTEXT(tbl_1)*NOT(COUNTIF($B$25:B25, […]

Filter text values existing in the first range but not in the 2nd range

Click image to enlarge. Array formula in B26: =INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)=0)*NOT(COUNTIF($B$25:B25, tbl_1))*(ISTEXT(tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1, "")), MATCH(0, ISNONTEXT(INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)=0)*NOT(COUNTIF($B$25:B25, tbl_1))*(ISTEXT(tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1, […]

Filter unique text values from a range containing both numerical and text values

Array formula in B15: =INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*(COUNTIF(tbl, tbl)=1)*ISTEXT(tbl), ROW(tbl)-MIN(ROW(tbl))+1)), MATCH(0, ISNONTEXT(INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*(COUNTIF(tbl, tbl)=1)*ISTEXT(tbl), ROW(tbl)-MIN(ROW(tbl))+1)), , 1))+(COUNTIF(tbl, INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*(COUNTIF(tbl, […]

Extract duplicate text values from a range containing both numerical and text values

Array formula in B15: =INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*(COUNTIF(tbl, tbl)>1)*ISTEXT(tbl), ROW(tbl)-MIN(ROW(tbl))+1)), MATCH(0, ISNONTEXT(INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*(COUNTIF(tbl, tbl)>1)*ISTEXT(tbl), ROW(tbl)-MIN(ROW(tbl))+1)), , 1))+COUNTIF($B$14:B14, INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*(COUNTIF(tbl, […]

Extract unique distinct text list from a range containing both numerical and text values

Formula in B15: =INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*ISTEXT(tbl), ROW(tbl)-MIN(ROW(tbl))+1)),MATCH(0, ISNONTEXT(INDEX(tbl, MIN(IF((COUNTIF($B$14:B14,tbl)=0)*ISTEXT(tbl), ROW(tbl)-MIN(ROW(tbl))+1)), , 1))+COUNTIF($B$14:B14,INDEX(tbl, MIN(IF((COUNTIF($B$14:B14, tbl)=0)*ISTEXT(tbl),ROW(tbl)-MIN(ROW(tbl))+1)), , 1)), 0), 1) + CTRL […]

      Excel functions

      Compatibility

      BETADIST function

      BETAINV function

      BINOMDIST

      CHIDIST function

      CHIINV function

      CHITEST function

      CONFIDENCE

      COVAR function

      CRITBINOM

      EXPONDIST

      FDIST function

      FLOOR function

      FORECAST function

      FTEST function

      GAMMADIST

      LOGNORMDIST

      MODE function

      RANK function

      STDEV function

      Database

      DAVERAGE function

      DCOUNT function

      DCOUNTA function

      DGET function

      DMAX function

      DMIN function

      DPRODUCT function

      DSTDEV function

      DSTDEVP function

      DSUM function

      DVARP function

      Date and Time

      DATE function

      DATEDIF function

      DATEVALUE

      DAY function

      DAYS function [2013]

      EDATE function

      EOMONTH function

      HOUR function

      MINUTE function

      MONTH function

      NETWORKDAYS

      NETWORKDAYS.INTL [2010]

      NOW function

      SECOND function

      TIME function

      TIMEVALUE

      TODAY function

      WEEKDAY function

      WEEKNUM function

      WORKDAY function

      YEAR function

      YEARFRAC function

      Engineering

      BIN2DEC function

      BIN2HEX function

      BIN2OCT function

      BITAND function [2013]

      BITLSHIFT [2013]

      BITOR function [2013]

      BITRSHIFT [2013]

      BITXOR function [2013]

      COMPLEX function

      CONVERT function

      DEC2BIN function

      DEC2HEX function

      DEC2OCT function

      DELTA function

      Financial

      ACCRINT function

      ACCRINTM function

      CUMIPMT function

      CUMPRINC function

      DB function

      DOLLARFR function

      EFFECT function

      FV function

      IPMT function

      ISPMT function

      NOMINAL function

      PDURATION

      PMT function

      PPMT function

      PRICEMAT function

      RATE function

      Information

      CELL function

      ERROR.TYPE

      INFO function

      ISBLANK function

      ISERR function

      ISERROR function

      ISFORMULA [2013]

      ISLOGICAL

      ISNA function

      ISNONTEXT

      ISNUMBER function

      ISODD function

      ISREF function

      ISTEXT function

      N function

      NA function

      SHEET function

      SHEETS function

      TYPE function

      Logical

      AND function

      FALSE function

      IF function

      IFERROR function [2007]

      IFNA function [2013]

      IFS function [Office 365]

      NOT function

      OR function

      SWITCH function [2016]

      TRUE function

      XOR function [2013]

      Lookup and reference

      ADDRESS function

      AREAS function

      CHOOSE function

      COLUMN function

      COLUMNS function

      FORMULATEXT [2013]

      HLOOKUP function

      HYPERLINK

      INDEX function

      INDIRECT function

      LOOKUP function

      MATCH function

      OFFSET function

      ROW function

      ROWS function

      TRANSPOSE

      VLOOKUP function

      Math and trigonometry

      ABS function

      ACOS function

      ACOSH function

      ACOT function [2013]

      ACOTH function [2013]

      AGGREGATE

      ASIN function

      ASINH function

      ATAN function

      ATAN2 function

      ATANH function

      BASE function

      CEILING function

      COMBIN function

      COMBINA function [2013]

      COS function

      COSH function

      COT function [2013]

      COTH function [2013]

      CSC function

      DECIMAL function [2013]

      DEGREES function

      EVEN function

      EXP function

      FACT function

      FACTDOUBLE

      FLOOR.MATH [2013]

      FLOOR.PRECISE [2010]

      GCD function

      INT function

      LCM function

      LN function

      LOG function

      LOG10 function

      MINVERSE function

      MMULT function

      MOD function

      MROUND function

      MULTINOMIAL

      MUNIT function [2013]

      PI function

      POWER function

      PRODUCT function

      QUOTIENT function

      RADIANS function

      RAND function

      RANDBETWEEN

      SEC function

      SECH function

      SERIESSUM

      SIGN function

      SIN function

      SINH function

      SQRT function

      SUBTOTAL function

      SUM function

      SUMIF function

      SUMIFS function [2007]

      SUMPRODUCT

      SUMSQ function

      SUMX2MY2 function

      SUMX2PY2 function

      SUMXMY2 function

      TAN function

      TANH function

      TRUNC function

      Statistical

      AVEDEV function

      AVERAGE function

      AVERAGEA function

      AVERAGEIF [2007]

      AVERAGEIFS [2007]

      BETA.DIST [2010]

      BETA.INV function [2010]

      BINOM.DIST [2010]

      BINOM.INV [2010]

      CHISQ.DIST

      CHISQ.DIST.RT [2010]

      CHISQ.INV [2010]

      CHISQ.INV.RT [2010]

      CHISQ.TEST [2010]

      CONFIDENCE.NORM [2010]

      CONFIDENCE.T [2010]

      CORREL function

      COUNT function

      COUNTA function

      COUNTBLANK

      COUNTIF function

      COUNTIFS function [2007]

      COVARIANCE.P [2010]

      COVARIANCE.S [2010]

      EXPON.DIST [2010]

      F.DIST function [2010]

      F.DIST.RT [2010]

      F.TEST function [2010]

      FORECAST.LINEAR [2016]

      FREQUENCY

      GAMMA function [2013]

      GAMMA.DIST [2010]

      GEOMEAN function

      GROWTH function

      INTERCEPT

      LARGE function

      LINEST function

      LOGEST function

      LOGNORM.DIST [2010]

      MAX function

      MAXIFS function [2016]

      MEDIAN function

      MIN function

      MINA function

      MINIFS function [2016]

      MODE.MULT [2010]

      MODE.SNGL [2010]

      NORM.DIST [2010]

      NORM.INV function [2010]

      PERMUT function

      PERMUTATIONA

      PHI function

      PROB function

      QUARTILE.INC [2010]

      RANK.AVG function [2010]

      RANK.EQ function [2010]

      SKEW function

      SLOPE function

      SMALL function

      STANDARDIZE

      STDEV.P function [2010]

      STDEV.S function [2010]

      STDEVA function

      STDEVPA function

      TREND function

      TRIMMEAN function

      VAR.P function [2010]

      VAR.S function [2010]

      Text

      ASC function

      CHAR function

      CLEAN function

      CODE function

      CONCAT function [Office 365]

      CONCATENATE

      EXACT function

      FIND function

      FIXED function

      LEFT function

      LEN function

      LOWER function

      MID function

      REPT function

      RIGHT function

      SEARCH function

      SUBSTITUTE

      T function

      TEXT function

      TEXTJOIN function [Office 365]

      TRIM function

      UPPER function

      VALUE function

      Web

      ENCODEURL [2013]

      WEBSERVICE [2013]


      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you out.

    Feel free to comment and ask Excel questions.

    Make sure you subscribe to my newsletter so you don't miss new blog articles.

  • Free Blog Emails

    Get a free PDF book!

  • Search website