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

    Basic formulas


    Count

    Cells with text values

    Cells with empty values

    String in cell

    String in cell range

    Strings in cell range

    String in rng, case sens.

    Cells equal list values

    Containing any list value

    Rows containing data

    Pattern in cell value


    Dates

    Days between dates

    Weeks between dates

    Months between dates

    Years between dates

    Workdays betw. 2 dates

    Specific wkdays in rng

    Sum nums betw. dates

    Overlapping ranges

    Latest date - condition

    Match date in date rng

    Create date range


    Time

    Hours between times

    How to AVERAGE time

    Overlapping ranges


    Extract

    First word in cell value

    K-th word in cell value

    Last word in cell value

    First three digits in value

    Numbers in cell value


    Text string manipulation

    Replace part of formula


    Index match

    Critera - multiple results

    Case sensitive

    Multiple results

    Multiple conditions


    Lookups

    Get the latest revision

    Last value in column

    Last value unsorted list

    Extract using criteria(3)

    Lookup - two conditions

    Two-dimensional lookup

    Find closest value


    Logic

    If cell has value

    If cell contains any text

    Cell contains list value

    Cells equal to list value

    Cell contains list value

    If cell contains text

    Multiple conditions

    IF & AND - Conditions

    Nested IF functions


    Sum

    Sum by group

    Sum nums betw. dates

    Running totals

    Advanced totals

    Sum based on criteria

    Running totals - date


    Average function

    Average - criteria

    AVERAGE ignore NA()

    How to AVERAGE time

    Average - no blanks

    Average function

    Running average

    Average ignore 0


    Sumproduct function

    Nested IF functions

    SUMPRODUCT - blank

    SUMPRODUCT & IF

    Multiple conditions

    SUMPRODUCT

    SUMPRODUCT - count


    Match function

    Match nos & letters

    Critera - multiple results

    Small - Index Match

    Case sensitive

    Multiple results

    Match two columns

    Multiple conditions

    MATCH function

    Extract headers

    Two-dimensional lookup


    Small function

    SMALL - multiple rngs

    Small - Index Match

    SMALL - ignore 0

    SMALL with conditions

    SMALL function for text

    SMALL with dupes

    Multiple results

    SMALL function


    Min function

    How to use the MIN function

    Lookup using two criteria

    Based on month

    How to quickly find the maximum or minimum value [Formula]

    From a cell range

    Find closest value


    Max function

    How to use the MAX function

    Fuzzy vlookup [Array formula]

    Combine sheets

    Extract unique distinct values sorted based on sum of adjacent values

    Based on month

    How to quickly find the maximum or minimum value [Formula]


    Index function

    Rearrange cells in a cell range to vertically distributed values

    Numbers in cell value

    How to remove unwanted characters in a cell

    Identify all characters in a cell value

    How to remove numbers from a cell value

    Critera - multiple results

    Small - Index Match

    Case sensitive

    Multiple results

    Multiple conditions

    Rearrange values

    Find numbers closest to sum

    How to use the INDEX function

    Year - month from dates

    Two-dimensional lookup

    From a cell range


    Sum function

    Containing any list value

    Sum by group

    Sum nums betw. dates

    Running totals

    How to use the SUM function

    Count overlap. days(1)

    Strings in cell range

    Count overlapping dates

    Sum based on multiple criteria

    Sum values between two dates and based on a condition

    Sum values containing text based on a condition

    String in rng, case sens.

    Unique dist. values

    String in cell range

    Sum cells with check boxes

    Sum only visible cells




Count text values


Excel » Count values » Count text values »

Count a given pattern in a cell value

The formula in cell B6 counts how many times the string (D3) is found in a cell value (B3) even […]

      Basic formulas


      Count

      Cells with text values

      Cells with empty values

      String in cell

      String in cell range

      Strings in cell range

      String in rng, case sens.

      Cells equal list values

      Containing any list value

      Rows containing data

      Pattern in cell value


      Dates

      Days between dates

      Weeks between dates

      Months between dates

      Years between dates

      Workdays betw. 2 dates

      Specific wkdays in rng

      Sum nums betw. dates

      Overlapping ranges

      Latest date - condition

      Match date in date rng

      Create date range


      Time

      Hours between times

      How to AVERAGE time

      Overlapping ranges


      Extract

      First word in cell value

      K-th word in cell value

      Last word in cell value

      First three digits in value

      Numbers in cell value


      Text string manipulation

      Replace part of formula


      Index match

      Critera - multiple results

      Case sensitive

      Multiple results

      Multiple conditions


      Lookups

      Get the latest revision

      Last value in column

      Last value unsorted list

      Extract using criteria(3)

      Lookup - two conditions

      Two-dimensional lookup

      Find closest value


      Logic

      If cell has value

      If cell contains any text

      Cell contains list value

      Cells equal to list value

      Cell contains list value

      If cell contains text

      Multiple conditions

      IF & AND - Conditions

      Nested IF functions


      Sum

      Sum by group

      Sum nums betw. dates

      Running totals

      Advanced totals

      Sum based on criteria

      Running totals - date


      Average function

      Average - criteria

      AVERAGE ignore NA()

      How to AVERAGE time

      Average - no blanks

      Average function

      Running average

      Average ignore 0


      Sumproduct function

      Nested IF functions

      SUMPRODUCT - blank

      SUMPRODUCT & IF

      Multiple conditions

      SUMPRODUCT

      SUMPRODUCT - count


      Match function

      Match nos & letters

      Critera - multiple results

      Small - Index Match

      Case sensitive

      Multiple results

      Match two columns

      Multiple conditions

      MATCH function

      Extract headers

      Two-dimensional lookup


      Small function

      SMALL - multiple rngs

      Small - Index Match

      SMALL - ignore 0

      SMALL with conditions

      SMALL function for text

      SMALL with dupes

      Multiple results

      SMALL function


      Min function

      How to use the MIN function

      Lookup using two criteria

      Based on month

      How to quickly find the maximum or minimum value [Formula]

      From a cell range

      Find closest value


      Max function

      How to use the MAX function

      Fuzzy vlookup [Array formula]

      Combine sheets

      Extract unique distinct values sorted based on sum of adjacent values

      Based on month

      How to quickly find the maximum or minimum value [Formula]


      Index function

      Rearrange cells in a cell range to vertically distributed values

      Numbers in cell value

      How to remove unwanted characters in a cell

      Identify all characters in a cell value

      How to remove numbers from a cell value

      Critera - multiple results

      Small - Index Match

      Case sensitive

      Multiple results

      Multiple conditions

      Rearrange values

      Find numbers closest to sum

      How to use the INDEX function

      Year - month from dates

      Two-dimensional lookup

      From a cell range


      Sum function

      Containing any list value

      Sum by group

      Sum nums betw. dates

      Running totals

      How to use the SUM function

      Count overlap. days(1)

      Strings in cell range

      Count overlapping dates

      Sum based on multiple criteria

      Sum values between two dates and based on a condition

      Sum values containing text based on a condition

      String in rng, case sens.

      Unique dist. values

      String in cell range

      Sum cells with check boxes

      Sum only visible cells


      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