Syntax:= EveryN(Range, N)
Description: Returns every N values from a range of cells given.
EveryN is an array function. Select a set of cells (in a row) enter the formula and press Ctrl+Shift+Enter.
Example: Return every 5th value from the given cell range=EveryN(A1:A100,5)