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 |