View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johan johan is offline
external usenet poster
 
Posts: 34
Default 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