Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Lookup functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - EveryN function
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)

litLIB