You’ll be able to worth please see formulation to accomplish a LARGE IF serve as in Excel:
Method 1: LARGE IF with One Standards
=LARGE(IF(A2:A16="A",C2:C16),2)
This system unearths the 2d greatest price in C2:C16 the place the worth in A2:A16 is the same as “A”.
Method 2: LARGE IF with More than one Standards
=LARGE(IF((A2:A16="A")*(B2:B16="Guard"),C2:C16),2)
This system unearths the 2d greatest price in C2:C16 the place the worth in A2:A16 is the same as “A” and the worth in B2:B16 is the same as “Guard”.
Refer to examples display find out how to worth each and every system in follow with please see dataset in Excel:
Instance 1: LARGE IF with One Standards
We will worth please see system to search out the 2d greatest price in C2:C16 the place the worth in A2:A16 is the same as “A”:
=LARGE(IF(A2:A16="A",C2:C16),2)
Refer to screenshot presentations find out how to worth this system:
This tells us that the 2d greatest issues price amongst all avid gamers on crew A is 14.
Instance 2: LARGE IF with More than one Standards
We will worth please see system to search out the 2d greatest price in C2:C16 the place the worth in A2:A16 is the same as “A” and the worth in B2:B16 is the same as “Guard”:
=LARGE(IF((A2:A16="A")*(B2:B16="Guard"),C2:C16),2)
Refer to screenshot presentations find out how to worth this system:
This tells us that the 2d greatest issues price amongst all Guards on crew A is 7.
Spare Assets
Refer to tutorials provide an explanation for find out how to carry out alternative habitual duties in Excel:
How one can Virtue a Median IF Serve as in Excel
How one can Calculate the Ruthless and Same old Diversion in Excel
How one can Calculate the Interquartile Space (IQR) in Excel
