Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
counting unique valuesPosted by steven on December 28, 2001 4:06 AM
I have a range of numbers, say from a1 to a100. I would like to have a formula wich counts the unique numbers in this range
number of unique numbers = 3
|Check out our Excel Resources
Re: counting unique valuesPosted by Aladưn Akyurek on December 28, 2001 4:33 AM
The FREQUENCY formula that follows will give you the desired count:
where A1:A10 houses the numbers of ưnterest.
Re: counting unique valuesPosted by BobJ on December 28, 2001 8:51 AM
How about Text & Numbers?
Re: counting unique valuesPosted by Aladin Akyurek on December 29, 2001 7:10 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.