To find the nth nonblank value in a range

ramonchas

New Member
Joined
Mar 29, 2010
Messages
1
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
 

Forum statistics

Threads
1,085,157
Messages
5,382,040
Members
401,767
Latest member
JohnLeek

Some videos you may like

This Week's Hot Topics

Top