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
|