Select Multiple Excel rows

[system]

My data in excel looks like this:

I want to select multiple rows from this table based on the column KPI.
So selecting all rows concerning KPI01 and place them all nicely beneath each other.

How to do this?
VLOOKUP - doesn’t work cause it only get’s first value (and is performance bad)
INDEX-MATCH - doesn’t work cause you need array and that doesn’t work in xcelisus

---

Tiny (BOB member since 2004-11-10)

[system]

I found this post:

Insert Multiple Rows: Excel or Xcelsius

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)

but this wil only work if all your source excel rows which you need are located wright beneath each other. And in my case they are scattered throughout the source table

---

Tiny (BOB member since 2004-11-10)

[system]

Check out the “filtered rows” option for your selector. The most common implementation is a combo box. The combo box would allow you to select a KPI, and then move all the rows that match that KPI over to a different part of the sheet.

---

Lugh (BOB member since 2009-07-16)

[system]

@Lugh

Check out the “filtered rows” option for your selector. The most common implementation is a combo box. The combo box would allow you to select a KPI, and then move all the rows that match that KPI over to a different part of the sheet.

checked it out, also checked out some excel formula’s but apparently the selector with filtered rows has better performance :?

---

Tiny (BOB member since 2004-11-10)