Excel Magic Trick 1324

ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records?

DESCRIPTION

See how to extract records with a formula:
(00:17) Problem Introduction
(01:23) Use ROWS as the Number Incrementor in a Data Extraction Formula when the criteria does not change as the formula is copied. Formula Goal: Extract Records based on one condition / criteria.
(08:20) When to NOT use IFERROR function.
(10:26) Use COUNTIFS as the Number Incrementor in a Data Extraction Formula when the criteria changes as the formula is copied. Formula Goal: Extract Top Five Values and Names Associated with the Values.
(16:47) Extract Records with Formula based on two conditions / criteria.
(18:50) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply