Average of Consecutive Negative Numbers
|
Average Largest 5 column values, per Matching Id
|
Average of Last 20 Positive values only in a Column
|
Average of first 10 values in a column, Ignore Error Values
|
Average Last 10 column values, exclude Highest / Lowest
|
Position of First Text Character in a String
|
Ebook of Excel Formulas
|
Position of Last Numeric in a String
|
Calculate End Date (& Time) from Start Date (& Time) and Duration (Work Hours) in Excel
|
Extract the Number Preceding Specific Text in a String
|
Extract Text After Last Occurrence of a Number in a String
|
Position of First Number in a String
|
Extract Text after Last Blank Space in a String
|
Split Names - Extract First, Middle & Last Names in Separate Cells
|
Reverse First Name & Last Name
|
AVERAGE of Non Contiguous Cells which are Evenly Distributed - Odd or Even rows
|
AVERAGE of Non Contiguous Cells which are Unevenly Distributed
|
Sum Diagonal Cells in a Range
|
SUM Smallest 3 Values in Non-Contiguous Cells with Uneven Intervals
|
SUM Largest 4 Values in Non-Contiguous Cells of a Row
|
Assign separate Values to Non-Contiguous Cells and return SUM
|
SUM Non-Contiguous Ranges of a Column - SUM EACH block of consecutive cells
|
SUMIF for Non-Contiguous Cells, with Wildcards, for Date Range
|
SUM of - Last 12 values in a Column, Largest 5 out of Last 12 values, last 12 values Excluding Highest / Lowest
|
SUM Cell values containing any of the Multiple Values in Full or in Part
|
SUM Max values of Each Row, in a Multiple Column Range
|
SUMIF with Date Range, Multiple Month Names / Numbers & Year
|
SUM AND / OR Criteria for Multiple Columns
|
Sumif to Exclude Cells Hidden by a Filter
|
Sumif to Exclude Cells Hidden with the Hide Rows command
|
Countif Multiple Criteria, relate Criteria to a Value, return SUM
|
Count Cells in Non-Contiguous Ranges, where a value occurs in whole or in part
|
COUNTIF for Non-Contiguous Cells, with Wildcards, for Date Range
|
Count Occurrences of a Value in Column, as a whole or in part
|
Countif Array Criteria, Multiple Columns, AND / OR conditions
|
Countif with Array Criteria, using AND / OR criteria
|
Count number of Cells containing Specific Letter(s)
|
Count Multiple Occurrences of Array Values
|
SUM Values for Names which appear only Once
|
Count Rows with occurrence of atleast one number
|
Count Continuous Non-Blank cells which appear Last
|
Count Groups of Consecutive Positive Values
|
Count Maximum Number of Consecutive Occurrences of a Value
|
Count Rows containing Multiple specified Values
|
Count Uniques, Multiple AND / OR Conditions
|
Count Unique Names, where Name corresponds to Multiple Values
|
Count Unique Values matching any one of the Multiple values
|
Count Uniques, Condition in One or Both Columns
|
Count Once for Occurrence of a Value in all columns of Same Row
|
Count Uniques Appearing in Only One or in Both Columns
|
Count Unique values in a Column, with Conditions
|
Count Unique Values in Excel
|
Split Values into Multiple Equal Groups
|
Rank Text Values in Custom Order
|
Rank & Sort Column Values, Ignoring Error Values
|
Extract a Sorted List of Unique values in a column
|
Extract Duplicates once, which are Common in 2 Columns
|
Extract Values which appear ONLY once, from a Column
|
Extract Unique sub-strings of 1st 5 Characters from each column cell
|
Unique List, Sorted in Ascending Order, Appearing in One Column and Not in Other
|
Unique List Appearing in One Column and Not in Other
|
Unique List from Single Column, Skip Specific Values
|
Unique List from Single Column
|