Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
 

Software categories:
litLIB
Request new function
Download
Order
litLIB Help
Chemistry Functions
Date & Time Functions
Excel Functions
File System Functions
Logical Functions
Lookup Functions
Misc Functions
Numeric Functions
String Functions
System Functions
Web Functions
Vector and Matrix Functions
All Functions Index
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 Misc functions

Buy now

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

litLIB Help - Unique function
litLIB Help
Product pages :
 litLIB
Quick links:
help index
forums

Misc - Unique

Syntax:
=Unique(Source)

Description:
Returns an array with unique values. Note that this is an array formula!. To enter this formula select the cells where you would like to display the unique list of values. For example B1:B10. Then enter the formula, e.g. =Unique(A1:A100). Press Alt-Enter to confirm the formula. Excel will display {=Unique(A1:A100)} indicating it is an array formula. Source : Range of cells to find the unique values in.

Example:
 =Unique(A1:A10)

litLIB

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