Finding The Nth Greatest Value Meeting Criteria

Problem:

Listed in Range A2:C6 are players (column C) and their matching teams and scores (columns D:E).
How could we create a formula that will retrieve the second highest score in column C matching each team in column E?

Solution:

Using the LARGE function in an array formula, as follows:
{=LARGE(($B$2:$B$6=E2)*($C$2:$C$6),2)}

(To create Array formula: select the cell after typing the formula,press F2 and then press Ctrl+Shift+Enter)

I am having trouble finding the LARGE() function in my SPANISH version of Excel. Is there a dictionary somewhere or a way to find out the equivalent names in Spanish?

In Access you can type the English function and the application understand and translate it, but the same functionality was not included in Excel.

Hi DeepField,

Originally Posted by DeepField

I am having trouble finding the LARGE() function in my SPANISH version of Excel. Is there a dictionary somewhere or a way to find out the equivalent names in Spanish?

In Access you can type the English function and the application understand and translate it, but the same functionality was not included in Excel.

One option may be to create a workbook with the language set to English version with a LARGE formula, and then open it with the language set to Spanish version.

No idea if it will work, but seems like it might!

HTH,

Alan.

i world like to know other kind of formula like sorting like below

2
1
0
-1
-2
-3

if any body know this kind of formular could you please send me it.