To find the nth nonblank value in a range

[ramonchas]

I found the next formula in microsoft, it works perfectly, but is there anyway of doing the same thing without using an array formula.

The thing is that I am working with Xcelsius 2008 and it does not support neither ROW or the COLUMN formulas, and I guess is because it does not support array formulas at all. Any help, I'm really strugling with it.

=INDEX(range,SMALL(IF(ISBLANK(range),"",ROW(range)),n)-ROW(range)+1)

http://support.microsoft.com/kb/101167