How to identify mins of maxes across data groups
Suppose I took all the students in Big Class and put them in groups by gender and age, e.g. 12yo boys in one group, 12yo girls in another, etc. With that setup, I'd like to create a formula column that has a 1 if that group has the shortest maximum height for their age across both genders, and a 0 otherwise. For example, in this data: GroupNameHeightNEW COLUMN12yo GirlsKATIE590 JANE550 JACLYN660 L...