Skip to Content
0
Former Member
Feb 17, 2009 at 06:33 AM

Searching and sorting in Xcelsius

21 Views

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