Count visible rows with criteria
In this example, the goal is to count visible rows where Region="West". Row 13 meets this criteria, but has been hidden. The SUBTOTAL function can easily generate sums and...Read more
Dave Bruns
VLOOKUP calculate shipping cost
This example shows how to use the VLOOKUP function to calculate the total shipping cost for an item in one formula, where the cost per kilogram (kg) varies according to weight. This requires an "approximate match" since in most cases the actual...Read more
Two-way lookup with INDEX and MATCH
In this example, the goal is to perform a two-way lookup, sometimes called a matrix lookup. This means we need to create a match on both rows and columns and return the value at the intersection of this two-way match
The core of this formula is INDEX, which is simply retrieving...Read more
Shortcut recipe: fill in missing data
In this lesson, we demonstrate a shortcut recipe you can use to fill in missing data from other cells.
Shortcut recipe: remove specific rows
In this lesson, we demonstrate a shortcut recipe you can use to remove rows that meet specific criteria quickly.
Shortcut recipe: delete blank rows
In this lesson, we demonstrate a shortcut recipe you can use to remove blank rows quickly.
Shortcuts for charts
In this lesson, we cover shortcuts you can use when working with Excel charts.
Shortcuts for Excel Tables
In this lesson, we cover shortcuts you can use when working with Excel Tables.
Shortcuts to group, ungroup, and outline
In this lesson, we cover shortcuts you can use to group and outline data.
Shortcuts to hide/unhide rows and columns
In this lesson, we cover shortcuts you can use to hide and unhide, rows and columns.