# Array Formula&#039;s using Large

• 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

• HI

Try using

=LARGE(IF(GRP=1,RATIO),1) entered as an array.

Personally though I would use the DMAX or a simple Pivot table.

• You were close, I put in your formula like this;

{=If(GRP=1,LARGE(RATIO,1),""} and it worked fine.

HTH

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!