See how to Conditionally Format Every 5th Value and Extract Every 5th Value:
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.