Thread: Generate Excel data list from complex matrix
View Single Post
 
Old 12-06-2019, 08:51 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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.
Attached Files
File Type: xlsx msofficeforums43988course selection.xlsx (12.8 KB, 6 views)
Reply With Quote