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
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.
My Error message says that I have entered too few agruments for this function.
If anyone can assist that would be appreciated.