Did you enter the formulas as array formulas? After you type the
formula, you must press Ctrl+Shift+Enter rather than just Enter.
If you do this properly, Excel will display the formula enclosed
in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


wrote in message
...
Hi,
I went to look at the page but it does not seem to solve
my problem. I tried to use the example stated, but the
ans to the formula to the given table is 1 instead of 3!

I downloaded the example excel and also, the 4th example
should show 6 but instead, it shows 1..

help! i don't know how to change the formula so that it
shows 6 instead of 1...

val

-----Original Message-----
Hi Val,

I suggest you look he

http://www.cpearson.com/excel/duplic...CountingUnique

for a solution by Chip Pearson

tim

dolphinv4 wrote:
Hi,

I have a list of records as follows

Apple
orange
grape
apple
apple
grape
watermelon

I want to count the number of unique item above...ie,
the
end result should show 4
(apple,orange,grape,watermelon).

Is there a formula to do this?

Thanks!
Val
.