Counting unique values
 

I need to find a way to just count unique values. IS this possible?

Counting unique values
 

use


=sumproduct((range<"")/countif(range,range&""))



On Apr 1, 9:02*pm, doofus1981
wrote:
I need to find a way to just count unique values. IS this possible?

Counting unique values
 

Check out this link...

http://www.xldynamic.com/source/xld....CT.html#unique
--
HTH...

Jim Thomlinson


"doofus1981" wrote:

I need to find a way to just count unique values. IS this possible?

Counting unique values
 

"Jim Thomlinson" wrote in message
...
Check out this link...

http://www.xldynamic.com/source/xld....CT.html#unique

Not for the moment, they haven't brought me back up yet.

Counting unique values
 

Geez Bob... How do you expect me to answer questions if your site is down. ;-)

--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:


"Jim Thomlinson" wrote in message
...
Check out this link...

http://www.xldynamic.com/source/xld....CT.html#unique

Not for the moment, they haven't brought me back up yet.

Counting unique values
 

What about me?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jim Thomlinson" wrote in message
...
Geez Bob... How do you expect me to answer questions if your site is down.
;-)

--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:


"Jim Thomlinson" wrote in
message
...
Check out this link...

http://www.xldynamic.com/source/xld....CT.html#unique

Not for the moment, they haven't brought me back up yet.

Counting unique values
 

You don't post a lot of questions so I don't have to worry too much about
answering yours... ;-)
--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:

What about me?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jim Thomlinson" wrote in message
...
Geez Bob... How do you expect me to answer questions if your site is down.
;-)

--
HTH...

Jim Thomlinson


"Bob Phillips" wrote:


"Jim Thomlinson" wrote in
message
...
Check out this link...

http://www.xldynamic.com/source/xld....CT.html#unique

Not for the moment, they haven't brought me back up yet.

Counting unique values
 

Good one!

Jim Thomlinson wrote:

You don't post a lot of questions so I don't have to worry too much about
answering yours... ;-)