Hi,
I have a requirement for sorting and searching functionality in Xcelsius.Is that possible by using Excel formulas?For searching i have used this Excel formula =INDEX($B$2:$B$15,SMALL(IF($A$1:$A$15=$A$17,ROW($A$1:$A$15)),ROW(1:1))) the row function is not supported by Xcelsius.Is there any other way or idea to work out those functions in Xcelsius.
Regards
Bala