# Excel: How to Find First 3 Positive Numbers in Column

Often you may want to find the first 3 positive numbers in a column in Excel.

For example, you might have a column of values in Excel and you’d like to return the first 3 positive numbers:

The following example shows how to do.

## Example: Find First 3 Positive Numbers in Column in Excel

Suppose we have the following list of values in Excel:

Notice that some values are positive, some are negative, and some are zero.

To find the first 3 positive values in the column, we can first list out the numbers 1 through 3 in column C:

Next, we can type the following formula into cell D1 to find the first positive value in column A:

=INDEX(\$A\$2:\$A\$14,SMALL(IF(\$A\$2:\$A\$14>0,ROW(\$A\$2:\$A\$14)-ROW(\$A\$2)+1),C1))

We can then click and drag this formula down to cells D2 and D3 to find the second and third positive values in column A, respectively:

Column D now displays the first 3 positive values from column A: 9, 12, and 15.

Note that you can use this formula to find the first n positive values in a column.

For example, we could easily drag our formula down to more cells to list out the first 5 positive values from column A:

Column D now displays the first 5 positive values from column A.

Feel free to use this formula to list out the first n positive values from your own dataset.

## Additional Resources

The following tutorials explain how to perform other common operations in Excel: