Excel: Finding the nth Value That Meets a Condition


I've taken a formula from this article Excel: Finding the nth Value That Meets a Condition. Which I'm trying to use to find the first non-empty cell in a range: Example from article - =INDEX(range,SMALL(IF(ISBLANK(range),"",ROW(range)),n)-ROW(range)+1) My version - {=INDEX(V36:AB36,SMALL(IF(ISBLANK(V36:AB36),"",ROW(V36:AB36)),1)-ROW(V36:AB36)+1)} But it's not returning the first value, which is located in cell AB36. I think I'm using the second newest version of Excel (apologies for the vague description), which isn't listed as a compatible version in the article so perhaps the formula needs to be adapted? I am entering the formula as an array.. Thanks in advance. Thavethe nth Value That Meets a Condition


This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of September 22, 2014.


For more resources for Microsoft Excel