Set

[smilingjohn]

Hi all iam trying to count the key , where Status is not equaul to Class, Student and name... Other than this it has to count everything

Is this expression correct ?

=count(distinct {<Status -= {'class','name','Student'}>}Key)

[tresesco]

Looks correct.

[its_anandrjs · Accepted solution]

Yes expression is correct

Set Analysis

=count(distinct {<Status -= {'class','name','Student'}>}Key)

With If you can do this way

If condition

=Count(distinct if(Not Match(Status,'class','name','Student'), Key))

[pradosh_thakur]

Hi John

if the editor shows you red ignore it.

please go through this once to avoid confusion in future in case of case sensitivity etc.

Quotes in Set Analysis