Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of unique datafields in a column
Hello,
Does somebody know if there is a formule which I can put into a specific datafield and which shows me the number of unique datafields in another compleet column. For example; - formula in datafield A2, which shows in this example "5", because in column B are at this moment 5 unique values (or letters) registered. - in column B registered field B1 till B10 with the values; 2, 2, 3, 3, 4, 4, 5, 5, 6, 6 regrds, Johan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of unique datafields in a column
Do you mean unique values in a range?
If so try this with the range changed to suit =SUMPRODUCT((A2:A10<"")/COUNTIF(A2:A10,A2:A10&"")) Mike On Mon, 19 Oct 2009 08:15:25 -0700 (PDT), johan wrote: Hello, Does somebody know if there is a formule which I can put into a specific datafield and which shows me the number of unique datafields in another compleet column. For example; - formula in datafield A2, which shows in this example "5", because in column B are at this moment 5 unique values (or letters) registered. - in column B registered field B1 till B10 with the values; 2, 2, 3, 3, 4, 4, 5, 5, 6, 6 regrds, Johan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of unique datafields in a column
Works oke.
Thanks a lot. regards, Johan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique values in column | Excel Discussion (Misc queries) | |||
Counting the number of unique values within a range | Excel Discussion (Misc queries) | |||
Counting Unique Vales in a column | Excel Worksheet Functions | |||
Unique number counting | Excel Discussion (Misc queries) | |||
Counting unique text/number cells from a range | Excel Discussion (Misc queries) |