Insert Multiple Rows: Excel or Xcelsius

system · September 16, 2008, 8:32pm

Hello All,

Attached is an example. Is there a way we can achieve this without using auto filter and macros? i.e when i insert the date in cell A1 (Using the calender Component) , it should lookup from the range B2:D20 and show all the rows for that date in the range F2:H20.

I tried using the ROW and ROWS functions in Excel, however these functions are not supported in Xcelsius 2008

I hope i was understandable.

Regards
ExcelQuestion.xls (14.0 KB)

RohitCX (BOB member since 2008-09-09)

system · September 16, 2008, 8:46pm

You will find the answer to your problem there:
http://ryangoodman.net/blog/index.php/2007/03/28/dynamic_excel_lookup_logic_for_xcelsius

rochero (BOB member since 2004-10-05)

system · September 16, 2008, 9:21pm

Thanks,
That did the trick.

RohitCX (BOB member since 2008-09-09)

system · September 22, 2008, 6:09am

Hi Rohit,

 We will get these results buy using some formulas in excel
 1.countif   2.index 3.match

  Review the source files below.

Regards,
Chitta
calender.zip (7.0 KB)

chitta (BOB member since 2008-09-02)