-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: Which is the most hair-raising South African mountain pass you've driven?
Excel Fundis Needed
- Thread starter Progenix Oj101
- Start date
My apologies, I have been otherwise distracted.
This demo file uses my index formula solution, but also implements a dynamic array to make a list of all the data items in the table, then use that list in the dropdown box. The dynamic array varies by length and uses excel's array formulas (you'll see the formulas in curly brackets). Basically you can use array formulas to process a vector or matrix of data all in one cell, or also return multiple values from single formula across multiple cells. It sounds more complicated than it is. All you have to remember is to enter or edit an array formula, select all the cells in the array together, press F2 to edit, then press ctrl-shift-enter (CSE) to confirm the formula.
This demo file uses my index formula solution, but also implements a dynamic array to make a list of all the data items in the table, then use that list in the dropdown box. The dynamic array varies by length and uses excel's array formulas (you'll see the formulas in curly brackets). Basically you can use array formulas to process a vector or matrix of data all in one cell, or also return multiple values from single formula across multiple cells. It sounds more complicated than it is. All you have to remember is to enter or edit an array formula, select all the cells in the array together, press F2 to edit, then press ctrl-shift-enter (CSE) to confirm the formula.
LaraC
Honorary Master
- Joined
- Mar 11, 2014
- Messages
- 42,673
- Reaction score
- 1,847
Cool!
The first table on the dashboard doesn't accept values other than the first item entry.
How will the table react when additional criteria are inserted on the data sheet?
OT. How did you attach an Excel workbook in your post?
Excel FTW. If you think this is cool, you should see my Excel COVID tracker.Cool!
You 5* debugger! I messed up the formula in the first dashboard table during testing. Fixed now. The formulae are fairly robust to config, criteria and even score additions. You basically just make each table bigger and match it in size in the dashboard. I added one to test.
ZIP is your friend.OT. How did you attach an Excel workbook in your post?