Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Excel
A
Average, Largest 3 Values (Updated October 28, 2024)
Average, Largest 3 Values from the Last 5 Rows (Updated October 29, 2024)
Average, Largest 3 Values from the Last 5 Values (Updated October 30, 2024)
Average, Last 3 Rows (Updated October 31, 2024)
Average, Last 3 Values (Updated October 31, 2024)
Average, Last 3 Values Greater than Zero (Updated November 13, 2024)
Average, Multiple Criteria (Updated November 1, 2024)
Average, Single Criteria (Updated November 1, 2024)
C
Count, Multiple Criteria (Updated November 2, 2024)
Count, Number of Times 'X' Occurs 10 Times in any Row (Updated November 2, 2024)
Count, Single Criteria, Filtered List (Updated November 2, 2024)
Count, Single Criteria, Multiple Sheets (Updated November 3, 2024)
Count, Unique Values (Updated November 22, 2024)
Count, Words in a Text String (Updated November 16, 2024)
D
E
Extract, First Word from a Text String (Updated November 12, 2024)
Extract, Last Word from a Text String (Updated November 12, 2024)
Extract, Numeric Characters from a Text String (Updated November 9, 2024)
Extract, Third Word from a Text String (Updated November 12, 2024)
L
Lookup, Closest Match (Updated November 13, 2024)
Lookup, First Positive Value (Updated November 13, 2024)
Lookup, Last Instance of a Value and Return the Corresponding Value
Lookup, Last Positive Value (Updated November 13, 2024)
Lookup, Least Frequently Occurring Value
Lookup, Most Frequently Occurring Value
Lookup, Single Criteria, Filtered List
Lookup, Single Criteria, Multiple Sheets
M
R
S
Sum, Single Criteria, Filtered List
Sum, Single Criteria, Multiple Sheets