|
Position of First Text Character in a String
|
|
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 Uniques in Column, Array Criteria Match
|
|
Count Uniques, Condition in One or Both Columns
|
|
Count Once for Occurrence of a Value in 2 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 or Duplicate Values
|
|
Split Values into Multiple Equal Groups
|
|
Rank Text Values in Custom Order
|
|
Rank & Sort Column Values, Ignoring Error Values
|
|
Sorted Unique List of Values, only Text or only Numbers
|
|
Extract Duplicates once, which are Common in 2 Columns
|
|
Extract Values which appear ONLY once, from a Column
|
|
Unique sub-strings from each cell string in Column, of fixed or variable length
|
|
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
|
|
Last used row number and cell address, last numeric or text value in column
|
|
Left Lookup with Vlookup Excel Function
|
|
Left Lookup with Index, Match and Offset Excel Functions
|
|
Shade Alternate Rows - Conditional Formatting
|
|
Count Number of Unique Values in a Range (with Excel Functions)
|
|
Remove Duplicates or Create a List of Unique Records using Advanced Data Filter
|
|
Remove Duplicates or Create a List of Unique Records using Excel Formula
|
|
Remove Duplicates in a range, using "Remove duplicates" button in Data Tools
|
|
Find 'Smallest', 'Largest', 'K-th Smallest' and 'K-th Largest' Numbers in a Range
|
|
Excel Date and Time Functions and Formulas
|
|
Vlookup Multiple Values - Return MULTIPLE corresponding values for ONE Lookup Value
|
|
Case Sensitive Vlookup in Excel; Finding the 1st, 2nd, nth or last occurrence of the Lookup Value
|
