| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i count the number of unique values in a given column?
Thanks Domenic. This is the same suggestion i received from Ron - and it
works pefectly! "Domenic" wrote: If you download and install the free add-in Morefunc.xll, you can use COUNTDIFF... http://xcell05.free.fr/english/morefunc/countdiff.htm Otherwise, try... =SUMPRODUCT((Range<"")/COUNTIF(Range,Range&"")) Hope this helps! In article , Bobby wrote: I have a huge data extract that i'm trying to sort through. The first thing I want to do is count the number of unique entries in a given column. For example, in my extract a "name" comes up many times - i want to count how many "unique" names I have on my data sheet, in a specific column. I'm pretty sure this is easily done with pivot tables - but can't figure it out myself. (the pivot table keeps summing stuff up - it's not "counting"). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Match formula that pulls unique values from another column? | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
Threaded Mode
