count set analysis

[SonOfJeffGoldblum]

I have a table that shows role, name, and max count of times among all persons who has filled the role the most (ignore the duplicate "Speaker - ?" instances here).

Role	Name	#
Captain	George Costanza	3
Treasurer	Kosmo Kramer	2
Minutes	Elaine Benes	3
Speaker	Bob Sakamano	1
Speaker - ?	Kosmo Kramer	1
Speaker - ?	Tim Watley	1
Evaluator	Tim Watley	2
Timer	Bob Cobb	4
Visitor	Estelle Costanza	18

How can I show if a role has a tie for # times filled? The resulting table would show the two extra Speaker Instances here.

=count({<Role-={"Analyst"}>}Name)

Limitation: Role: Fixed Number = 7

Limitation: Name: Fixed Number = 1

[SonOfJeffGoldblum · Accepted solution]

Solution:

Using Ranking

=if(rank(count(Role),1,0)=1,count({<Role-={"Attendee"},Name={"=count(Name)"}>}Role))