I am trying to use an Array Formula to obtain the value of the nth Largest Ratio within each group. The actual table contains multiple columns. For this example I am trying to find the Largest ratio within each Group. A sample table is
Group Ratio
1 15
1 11
1 5
2 6
2 8
2 2
3 12
3 8
3 2
This is only a small sample. I have over 300 rows overing 12 different groups with multiple columns
Assuming the data range is named GRP and the Ratio values RATIO I have tried the following formula.
{=LARGE(IF(GRP=1,RATIO,1))}
My Error message says that I have entered too few agruments for this function.
If anyone can assist that would be appreciated.
Regards