Excel Topics

A

Average, Largest 3 Values

Average, Largest 3 Values from the Last 5 Values

Average, Last 3 Non-Zero Values

Average, Last 3 Values

Average, Multiple Criteria

Average, Single Criteria

___
Top

C

Count, Instances where X Occurs 10 Times in any Row

Count, Multiple Criteria

Count, Single Criteria, Filtered List

Count, Single Criteria, Multiple Sheets

Count, Unique Values

Count, Words in a Text String

___
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

L

Lookup, Closest Match

Lookup, Filtered List

Lookup, First Positive Number

Lookup, Last Instance of a Value and Return the Corresponding Value

Lookup, Last Non-Zero Value

Lookup, Last Numerical Value

Lookup, Last Text Value

Lookup, Last Value Regardless of Data Type

Lookup, Least Frequently Occurring Value

Lookup, Most Frequently Occurring Value

Lookup, Multiple Criteria

Lookup, Multiple Sheets

Lookup, Two Dimensional

___
Top

M

Maximum, Multiple Criteria

Maximum, Single Criteria

Minimum, Multiple Criteria

Minimum, Single Criteria

___
Top

R

Rank, Consecutive

Rank, Unique

Return, Workbook Name

Return, Workbook Path

Return, Workbook Path, Workbook Name, and Worksheet Name

Return, Worksheet Name

___
Top

S

Sum, Every Second Row

Sum, Largest 3 Values

Sum, Last 3 Values

Sum, Multiple Criteria

Sum, Single Criteria, Filtered List

Sum, Single Criteria, Multiple Sheets

___
Top