litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Lookup - EveryN

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)