Get Digital Help
  • Home
  • Functions
  • Charts
  • Formulas
  • Products
  • Archive
  • Contact
  • About Me
    • About me
    • Blogs I read

    Basic formulas


    Count

    Count a given pattern in a cell value

    Count cells with text

    Count rows with data

    Count cells equal to any value in a list

    Count cells containing text from list


    Dates

    WEEKDAYS between two dates

    Days between two dates

    Sum between two dates

    Use MEDIAN function to calculate overlapping ranges


    Extract

    Extract k-th word in cell value

    How to extract numbers from a cell value

    Extract last word in cell

    Extract first word in cell

    LEFT function for numbers


    Index match

    INDEX and MATCH – multiple criteria and multiple results

    INDEX MATCH – Case sensitive

    INDEX MATCH – multiple results

    INDEX MATCH with multiple criteria


    Logic

    If cell has value

    If cell contains any text

    If cell contains multiple values

    If cell equals value from list

    If cell contains text from list

    If cell contains text

    Use IF + COUNTIF to perform numerous conditions

    IF with AND function – multiple conditions

    Nested IF functions


    Lookups

    How to perform a two-dimensional lookup


    Text string manipulation

    How to replace part of formula in all cells

    Extract unique distinct values based on the 4 last characters


    Sum

    Sum by group

    Sum between two dates

    Running totals


    Time

    How to AVERAGE time

    Use MEDIAN function to calculate overlapping ranges


    Vlookup and return multiple values

    Lookup multiple values in different columns and return multiple values

    Unique distinct list sorted alphabetically based on a condition

    Use VLOOKUP and return multiple values sorted from A to Z

    Lookup and return multiple values on the same row from a range excluding blanks

    Use a drop down list to search and return multiple values

    Vlookup across multiple sheets

    Vlookup a cell range and return multiple values

    Vlookup – Return multiple unique distinct values

    Vlookup with multiple matches returns a different value

    Lookup values in a range using two or more criteria and return multiple matches in excel, part 2

    Lookup values in a range based on criteria and return multiple values

    Lookup multiple values in a range and return multiple corresponding values

    Vlookup with 2 or more lookup criteria and return multiple matches

    Search values distributed horizontally and return corresponding value

    5 easy ways to VLOOKUP and return multiple values

    Search for a cell value in a dataset




INDEX MATCH – Case sensitive

The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]

Filter unique distinct and duplicate values from a large data set

In this post I am going to describe how to filter duplicate and unique distinct values from a really large […]

Filter unique distinct values (case sensitive) [Excel UDF]

The User Defined Function demonstrated in the above picture extracts unique distinct values also considering lower and upper case letters. […]

Case sensitive lookup and return multiple values

The array formula in cell F5 returns adjacent values from column C where values in column B matches the search […]

Count unique distinct values

This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]

      Formula categories

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

    Feel free to comment and ask Excel questions.

    Don´t forget to add my RSS feed and subscribe to new blog articles by email.

  • Free Blog Emails

  • Search website