#1
|
|||
|
|||
Generate Excel data list from complex matrix
I have a matrix which shows various courses by major and levels at a university. Tagging is by Required and Optional courses.
Need help to show the list view of required and optional courses based on your selection of major and and level - I have already created a data validation list for that. Excel file attached. |
#2
|
|||
|
|||
Design your app as database. This way you don't need to design it anew whenever new courses, majors, or major levels are added. And you also will have the possibility to add other reports without any base design changes in future.
Attached is an example. There are some hidden columns on sheets, and a hidden sheet needed to get Tables on report sheet without row gaps. When you need a table like in your example, then this will be another report. |
#3
|
|||
|
|||
Thank you soo much!! This is a terrific way - have not used it before!!
|
#4
|
||||
|
||||
Another way in the attached.
Not especially easy-to-maintain array-entered formulae in blue shaded cells. I altered your data validation because yours didn't seem quite right. |
#5
|
|||
|
|||
Quote:
What was the logic of using Small function? I have only used it in the past to get the lowest value in the dataset. |
Tags |
list view, matrix |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) | wvlls | Word VBA | 1 | 03-22-2019 02:29 PM |
Extract a matrix of another matrix defined by selected rows marked with an x | Tommy7571 | Excel | 19 | 03-20-2019 08:39 AM |
VBA or Macros to generate List | asante_za | Excel Programming | 1 | 09-29-2017 09:51 AM |
2nd matrix gives a resut that doesnīt match numbers in the 1st matrix | Diver | Excel | 25 | 02-22-2017 04:39 PM |
trasforming word list in Excel matrix | abury | Word VBA | 1 | 02-15-2016 03:35 PM |