Here’s how to use icount() function.
Description:
Count the number of distinct members in a sequence.
Syntax:
A.icount() |
Note:
The function calculates the number of distinct members in a sequence A.
Parameter:
A |
A sequence of n members |
Option:
@o |
Remove duplicates by comparing neighboring members |
@n |
Judge whether a member is distinct or not according to position when parameter A is a number sequence |
@b |
Judge whether a member is distinct or not according to the long type bit when parameter A is a number sequence |
Return value:
A numerical value
Example:
|
A |
|
1 |
=["a","c","d","e","f","a","a"] |
|
2 |
=A1.icount() |
5 |
3 |
=A1.icount@o() |
6 |
4 |
=[1,4,9,16,25,36,49,64,81,100,81] |
|
5 |
=A4.icount@n() |
10 |
6 |
=A4.icount@b() |
10 |