Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: Added EveryN function (Read 1989 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: Added EveryN function
08.03.10 at 10:59:43
 
litLIB: Added EveryN function
 
To litLIB a new function was added in the Lookup category: EveryN. EveryN extracts every N-th value from a list. EveryN takes the range of cells and the value of N and it returns every N-th value. EveryN is therefore an array formula.
 
Example:
Suppose you have a list of values in the range A1:A10: 1,2,3,....
If you want to extract every 3rd row enter the following array formula: EveryN(A1:A10,3)
 
Available in litLIB 2.0.7
 
See also:
Lookup - EveryN  
http://www.oraxcel.com/projects/litlib/help/everyn.html
Back to top
 
« Last Edit: 08.03.10 at 11:00:26 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1