Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Count Only one time occurrence in column

Hi Everyone,

I am trying to count the Nymbers where Number are not Repeated in ColA

ColA
25
67
25
25
67
54
54
15
25

here
25 is Repeated 4 Time’s
67 is Repeated 2 Time’s
54 is Repeated 2 Time’s
15 is Repeated only once
Also Blank Cell should be Omitted

So Count should be 1

Thanks

0 6 315
6 REPLIES 6
Top Labels in this Space