• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Scrollable list

A

ashl

Member
Hi,


What is the best formula to use to make a scrollable list of details?


The list is based on the top 5 products. I have a drop down where you can choose one of the top 5 and the idea is you are able to scroll through the basic details of that product.


I havefound the following formula which I've tried using but entails having the headers in order. Since my data is not in sequential oder it doesn't work. I want the list dynamic so it changes with the top 5.

the formula is iferror(index(data_tbl;smallest(wenn(data_tbl=$D$17;row(Data_tbl));$C21);match(D$20;Data_Headers_tbl;0));"No Data")


Is tehre another way I could create a list of details dependant on the top 5, that also doesn't use much space as my data set wil be growing. I was thinking using an array formula of when,vlookup and match? Am I on the right track?


:) Thanks
 
I'm not a fan of the offset formula as its so volatile, ive used it a few times and Ive had to then go work around it. Its for a dynamic dashboard so it needs to be reliable for when other people use it.
 
Hi Ashl... see this for a start

http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/


You can replace OFFSET with INDEX to get same result.
 
You must log in or register to reply here.
Back
Top