Karthik-Excelsior
Active Member
- Joined
- Mar 4, 2011
- Messages
- 313
Hi Excel gurus,
I've a data set as given on this trix https://docs.google.com/spreadsheet/ccc?key=0Ao7RzFobcTErdGdqd0JISnRTMnVuaFlNR29EeEM2LXc&pli=1#gid=0
To the right of the data set, I've a table which shows the output. I would like to fill this table with data based on some selections that I make from the two drop-downs provided for 'Category' & 'Number set' . And based on the selections made, I would like to populate the top 5 products by volume. If you look at the sheet in the link given above, you'll get more clarity. Also, I've given a sample output table right below the output table on the sheet.
Any help is much appreciated. Thanks!
Karthik
I've a data set as given on this trix https://docs.google.com/spreadsheet/ccc?key=0Ao7RzFobcTErdGdqd0JISnRTMnVuaFlNR29EeEM2LXc&pli=1#gid=0
To the right of the data set, I've a table which shows the output. I would like to fill this table with data based on some selections that I make from the two drop-downs provided for 'Category' & 'Number set' . And based on the selections made, I would like to populate the top 5 products by volume. If you look at the sheet in the link given above, you'll get more clarity. Also, I've given a sample output table right below the output table on the sheet.
Any help is much appreciated. Thanks!
Karthik