Get Digital Help
  • Home
  • Functions
  • Formulas
  • Charts
  • CF
  • Pivot tables
  • VBA
  • Archive
  • Contact

    COLUMN function

    Rearrange cells in a cell range to vertically distributed values

    How to use the COLUMN function

    Match two criteria and return multiple records

    5 easy ways

    Search for a text string in a data set and return matching records

    Remove blank cells


    COLUMNS function

    Rearrange cells in a cell range to vertically distributed values

    How to use the COLUMNS function

    Filter records that contain numeric values

    Dynamic scoreboard

    Common records

    Horizontal vlookup


    INDEX function

    Pattern in cell value

    Match a range value containing both text and numerical characters

    Rearrange cells in a cell range to vertically distributed values

    Get the latest revision

    Numbers in cell value

    How to remove unwanted characters in a cell

    Identify all characters in a cell value

    Weekdays in date range

    How to remove numbers from a cell value

    Critera - multiple results

    Case sensitive

    Multiple results

    Multiple conditions

    Rearrange values

    Dynamic scoreboard

    Find numbers closest to sum

    Merge tables based on a condition

    How to use the INDEX function

    Calculate average of last 10 data with possible blank cells

    Extract unique distinct values based on the 4 last characters

    Dynamic team generator in excel

    Create a random playlist

    Year - month from dates

    Match two criteria and return multiple records

    Formula for matching a date within a date range

    Find latest date based on a condition

    5 easy ways

    Extract largest values from two columns

    Two-dimensional lookup

    Create a unique distinct list and sort based on frequency

    How to automatically fill all blanks with missing data or formula

    Sort a column alphabetically

    From a cell range

    Find closest value


    MOD function


    QUOTIENT function


    ROW function


    ROWS function

    Rearrange cells in a cell range to vertically distributed values

    How to use the ROWS function

    Dynamic scoreboard

    5 easy ways

    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


QUOTIENT function


Excel » Functions » Math and trigonometry » QUOTIENT function »

Rearrange cells in a cell range to vertically distributed values

The formula in cell B8 uses a named range to calculate the row and column needed to extract the correct […]

How to use the MOD function

The Mod function returns the remainder after a number is divided by divisor. The Mod function is short for the Modulo […]

      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