how to skip a specific row in an array

[images111]

Hi Guys, I'm trying to skip a specific row in an array, not the value.

For instance, assume we're on the A column:
0
3
0 <--- Row 3
0


how can I skip the 3rd row in A1:A4, so small(A1:A4, 2) can equal to 0, and small(A1:A4, 3) would equal to 3.
I would like to skip a specific row, not the value. I cannot switch the rows, I require a formula that ignores a specific row in an array

Thank you for the assistance!

[saravnepali]

Please Login or Register  to view this content.

will give 0 result

Please Login or Register  to view this content.

will give 3

Both are to be supplied as array formula

Hope this helps

Please NOTE

Instead of entering with the the "Enter" key, they need to be entered with Control + Shift + Enter. A formula entered this way will automatically appear with curly braces on either side in the formula bar — do not enter the braces manually.

[images111]

Thank you so much, I actually posted on another website but yours is much more simpler and cleaner. Thank you for the assistance.