Originally Posted by Spencer101

Hi,

Enter the below formula in cell C12 and confirm it as an array formula by pressing Ctrl, Shift & Enter rather than just Enter then copy down.

=LARGE(IF(B$2:B$8<=30,C$2:C$8,""),A12)

You will see if it's entered correctly as it will be in curly brackets { }