| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting unique values
I need to find a way to just count unique values. IS this possible?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... ;-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the # of unique values | Excel Worksheet Functions | |||
| Counting Unique Values | Excel Worksheet Functions | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| Counting unique values | Excel Worksheet Functions | |||
| Counting Unique Values | Excel Worksheet Functions | |||
Linear Mode
