|
|
|
|
-----Original 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...#CountingUniqu
e
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
.
.
|