To extract the largest nth figures for a given text criteria, use the following formula:

1. Replace "criteria" with the actual text criteria that you want to use.
2. Replace "B2:B10" with the range of numeric figures that you want to extract the largest nth figures from.
3. Replace "n" with the nth largest figure that you want to extract.
4. Use the following formula:
   
   
   Formula:

   =IFERROR(LARGE(IF(A2:A10="criteria",B2:B10),n),"No data") 


Note that this formula is an array formula, so you need to press Ctrl + Shift + Enter instead of just Enter to enter the formula.