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
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