ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Counting number of unique datafields in a column (https://www.excelbanter.com/excel-discussion-misc-queries/245878-counting-number-unique-datafields-column.html)

johan October 19th 09 04:15 PM

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

Mike H[_4_] October 19th 09 04:18 PM

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


johan October 19th 09 07:58 PM

Counting number of unique datafields in a column
 
Works oke.
Thanks a lot.

regards,
Johan.


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com