Question on dupes

[userid128223]

I have two fields like below.

Student	Head Teacher
Lucas	Mr Kien
john	Ms Amily
Tricia	Mr Muro
Deb	Ms Henry
Trump	Mr Kien
Kevin	Ms Corrine

Each student is suppose to have 1 head teacher. How can you identify students that has 2 head teachers and vice versa.

[mdmukramali · Accepted solution]

Hi,

=Count({<Student={"=Count( [Head Teacher])>=2"}>}Student)

[userid128223]

can you also do solution with aggr function?