Home/ Questions/Q 2072
Next
In Process
computing
  • 3
Asked: 2021-10-27T11:49:42+00:00 In:

Solved Excel Formula To Skip Blank Cells

  • 3

Is there a formula I can use to automatically skip blank rows and return only the values of a particular cell(s) that have numbers in them?

Share

    1 Answer

    1. Assuming your example data is in A1:A9, place this in B1 and drag it down to B9. It will list the values in ascending order:

      =SMALL($A$1:$A$9,ROW())

      Now, once you run out of values (in your case – 3) you’ll start to get a #NUM error.

      To prevent that, use ISERROR as follows:

      =IF(ISERROR(SMALL($A$1:$A$9,ROW())),””,SMALL($A$1:$A$9,ROW()))

      • 0