Calculation grouped by variable

[#1]

Hello,

I would like to find the maximum value from a column, but I need to group the data based on other columns; is it possible using a formula or a script?

As example, I would like to populate a new column with the maximum height, but divided by age, sex and nationality:

Nationality	Sex	Age	Height
ITA	M	25	180
USA	F	23	180
FRE	M	24	168
FRE	M	25	201
GER	F	23	160
ITA	X	23	175
ITA	X	24	158
CAN	M	25	193
USA	F	23	170
SPA	F	24	179
SPA	X	25	169
GER	F	23	163
GER	M	24	185
CAN	X	25	201
CAN	M	23	193
ITA	F	24	170
USA	F	25	180
FRE	X	23	179
FRE	F	23	169
GER	M	24	163
USA	M	25	185
SPA	F	23	180
SPA	M	24	179
GER	M	25	185
GER	F	23	201
ITA	X	24	193

Thank you in advance.

[#2 · Accepted solution]

Col Max( :Height, :Age, :Sex, :Nationality )

[#3]

Thank you so much! That's exactly what I was looking for!