Nov 04 2021 07:13 AM
Nov 04 2021 07:34 AM
Why 6? I count 7 unique numbers: 1, 2, 3, 4, 6, 7, 8
Nov 04 2021 07:45 AM
Nov 04 2021 02:02 PM
SolutionNov 05 2021 05:14 AM
Nov 04 2021 02:02 PM
SolutionAs variant
=SUM(--(FREQUENCY(A:A,A:A)>0) )
shall work for any version.