Excel Magic Trick 1373

Formula to Extract Every Nth Value & Conditionally Format Every Nth Value

DESCRIPTION

See how to Conditionally Format Every 5th Value and Extract Every 5th Value:
1. Introduction
2. Formula 1 for counting how many values will be extracted. ROWS & ROUNDDOWN Functions.
3. Formula 1 for counting how many values will be extracted. MAX and INT Functions.
4. Conditional Formatting Every 5th (Every Nth Row in Data Set) using a Logical Formula and the function: MOD Function. Discussion about why we use ROWS for Number Incrementor Formulas and not ROW function.
5. Extract Every 5th Row (Every Nth Row in Data Set) using INDEX, ROWS, and IF Function. Discussion about why we use IF Function and an Alternative Logcial Test rather than the IFERROR Function.
6. Summary.

WORKBOOKS

Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 471 times – 14 MB







Be the first to comment

Leave a Reply