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.
