Count Only one time occurrence in column

[Amit_Jain]

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

[Steve (Steve Coile)]

Try:

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

See also:

COUNT()

List from Table-Column Reference

List Subtraction

LIST()

[Amit_Jain]

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)

[Steve (Steve Coile)]

Ah, I misunderstood. Sorry.

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

[tsuji_koichi]

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

Is this?

[Amit_Jain]

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

[Suvrutt_Gurjar]

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”))