Hi

In successive rows I need to find the X Smallest of a dataset given another
dataset = a specific number.

Return the first smallest score for competitors in team 1
Return the second smallest score for competitors in team 1

I have used the following function to find the Largest

=SUMPRODUCT(LARGE(('Data Input'!C$3:C$126=1)*'Data Input'!G$3:G$126,1))

But for SMALL I need to omit zeros.

I have tried different variations of

=SUMPRODUCT(IF('Data Input'!K$3:K$126<0,(SMALL('Data
Input'!K$3:K$126,2)*'Data Input'!C$3:C$126=1)," "))

but can't seem to get it to work.

Any ideas would be gratefully received.