Using LARGE function with criteria
 

I have 2 columns of date. One with text and another with related numeric
figures. I am trying to craft a formula which will extract the largest nth
figures for a given text criteria. Any help would be appreciated. Thanks

Answer: Using LARGE function with criteria
 

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.

Using LARGE function with criteria
 

d1=LARGE(IF((A1:A10=c1),B1:B10),n)
text - column A
numrics - column b
c1 = text criteria
n - nt figure
it is an array formula. enter with ctrl+shift+enter
best wishes
sreedhar

"TT" wrote:

I have 2 columns of date. One with text and another with related numeric
figures. I am trying to craft a formula which will extract the largest nth
figures for a given text criteria. Any help would be appreciated. Thanks

Using LARGE function with criteria
 

With text in Column A and numbers in Column B, and text criteria in C1,
Try this *array* formula:

=LARGE(IF(A1:A15=C1,B1:B15),1)
--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

This is set for the *1st* largest!

Just change the last 1 in the formula for other positions.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TT" wrote in message
...
I have 2 columns of date. One with text and another with related numeric
figures. I am trying to craft a formula which will extract the largest nth
figures for a given text criteria. Any help would be appreciated. Thanks

Using LARGE function with criteria
 

Perfect. Much appreciated

"yshridhar" wrote:

d1=LARGE(IF((A1:A10=c1),B1:B10),n)
text - column A
numrics - column b
c1 = text criteria
n - nt figure
it is an array formula. enter with ctrl+shift+enter
best wishes
sreedhar

"TT" wrote:

I have 2 columns of date. One with text and another with related numeric
figures. I am trying to craft a formula which will extract the largest nth
figures for a given text criteria. Any help would be appreciated. Thanks