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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,089,992
Messages
5,411,712
Members
403,392
Latest member
Faster 72

This Week's Hot Topics

Top