» Retrieving Values from a List that are Greater than a Specified Number
We want to retrieve all the numbers from List1 (column A) that are greater than the number specified in cell B2.
Use the INDEX, SMALL, IF, and ROW functions as shown in the following Array formula:
Enter the formula in cell C2 and then copy it down the column until the #REF! error is returned.