Are values within a group equal

[harrietcosgrove]

I have a dataset where I need to check if within a group, everything appears the same number of times and mark them either yes or no.

For example, I have made a basic dataset where I have grouped by the first column and second column and done a count of the 'Name' in each group. I need to be able to mark if each name appears the same number of times as the other names in the group and then have a column which says YES or NO. I am struggling to create a formula to be able to compare with each other just within a group and then do the next group etc. I have tried the multi - row formula tool but not getting the output by group as I expected.

on this example, Group Name A, B and D would have "Yes" as all the names appear same number of times, Group Name C would have "No" as A appears 2 times and B and C appears once.

[Emmanuel_G]

@harrietcosgrove 

Find in attachement a way of doing this.

Let me know if there is any issue and please do not hesitate to mark this answer as solution if it helped.

[binuacs · Accepted solution]

@harrietcosgrove Another way of doing this

[harrietcosgrove]

Thank you! This worked, just needed to add in a unique tool for the specific data I was using as it was more complex but this solution is great :)