Added the Unique array formula to display a
list of unique values of a range.
litLIB 1.0.6
(20/April/2006)
Added the date & time
function: Quarter to determine the quarter of a date.
litLIB
1.0.5 (01/Dec/2005) Fix: There existed a conflict
with other Excel addins that create menu items on the toolbar.
Added functions:
HasFormula : Does a cell have a formula? =HasFormula(D12)
returns True of False
HasArray : Is a cell part of an array? =HasArray(D12)
returns True or False
WordCount : Count the number of words in a string
=WordCount("hello world") displays 2
WordsLeft : Return a number of words from the left
=WordsLeft("The fox jumps over the box",2) returns "The fox"
WordsRight : Return a number of words from the right of a text
=WordsRight("The fox jumps over the box",2) returns "the box"
WordsMid : Return words from the middle of a string
=WordsMid("The fox jumps over the box",2,3) returns "fox jumps
over"
PageNumber : Returns the page number a cell will be printed at
=PageNumber(D10) returns the page D10 will be printed on
PageCount : Returns the total number of printed pages
=PageCount() returns the total number of printed pages
litLIB
1.0.4 (29/Jul/2005) Added function:
ValidateVATNumber to validate EC VAT (Also called TVA or
mehrwertsteur) numbers.
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap