Count Only one time occurrence in column

AppSheet AppSheet Q&A
1

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

2

Try:

COUNT(table[ColA] - LIST(""))

See also:

1 Like
3

i tried your Formula but it’s showing Count of All Unique Number

what Actually i want to have Count of Numbers which are Appearing only once in column
(Skipping Blank and More then Once)

1 Like
4

Ah, I misunderstood. Sorry.

I’m not aware of a way to get only the unique values.

5

COUNT(UNIQUE(table[ColA] - LIST(“”)))

Is this?

1 Like
6

Same Result It’s also Counting Repeatable Number which are Appearing Again and again

7

Please try the following. However, the expressions could be sync time expensive.

Please create a VC called say [SortType] with an expression something like

IF( IN([_THISROW].[ColA], SELECT(Table Name[ColA], [_ROWNUMBER]<>[_THISROW].[_ROWNUMBER])), “Duplicate”,“UniqueValue”)

In another VC called say [UniqueCount] , please have an expression like

COUNT(SELECT(Table Name[SortType], [SortType]=“UniqueValue”))

1 Like