What's New

2023-01-18 | Dashboard | Dashboard to quickly view and analyze data

Excel

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

C

Count, Multiple Criteria

Count, Number of Times "X" Occurs 10 Times in any Row

Count, Single Criteria, Filtered List

Count, Single Criteria, Multiple Sheets

Count, Unique Values

Count, Words in a Text String

D

Dynamic Named Range

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

L

Lookup, Closest Match

Lookup, First Positive Value

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

Lookup, Least Frequently Occurring Value

Lookup, Most Frequently Occurring Value

Lookup, Multiple Criteria

Lookup, Single Criteria, Filtered List

Lookup, Single Criteria, Multiple Sheets

Lookup, Two Dimensional

M

Maximum, Multiple Criteria

Maximum, Single Criteria

Minimum, Multiple Criteria

Minimum, Single Criteria

R

Rank, Consecutive

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

T

Two Dimensional Lookup

W

Weeks of Supply