Excel Topics
A
Average, Largest 3 Values from the Last 5 Values
Average, Last 3 Non-Zero Values
___
Top
Top
C
Count, Instances where X Occurs 10 Times in any Row
Count, Single Criteria, Filtered List
Count, Single Criteria, Multiple Sheets
___
Top
Top
E
Extract, First Word from a Text String
Extract, Last Word from a Text String
Extract, Numeric Characters from a Text String
Extract, Third Word from a Text String
___
Top
Top
L
Lookup, Last Instance of a Value and Return the Corresponding Value
Lookup, Last Value Regardless of Data Type
Lookup, Least Frequently Occurring Value
Lookup, Most Frequently Occurring Value
___
Top
Top
M
___
Top
Top
R
Return, Workbook Path, Workbook Name, and Worksheet Name
___
Top
Top
S
Sum, Single Criteria, Filtered List
Sum, Single Criteria, Multiple Sheets
___
Top
Top

