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