Excel Fundis Needed

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.
 

Attachments

My apologies, I have been otherwise distracted.
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? :p
 
Excel FTW. If you think this is cool, you should see my Excel COVID tracker.

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?

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.

OT. How did you attach an Excel workbook in your post? :p
ZIP is your friend.
 

Attachments

Top
Sign up to the MyBroadband newsletter
X