Generate Excel data list from complex matrix

		Microsoft Office Forums > Microsoft Excel > Excel
Generate Excel data list from complex matrix

FAQ

Thread Tools

Display Modes

12-06-2019, 08:51 AM

p45cal

Windows 10 Generate Excel data list from complex matrix

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

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

msofficeforums43988course selection.xlsx (12.8 KB, 8 views)

Tags

list view, matrix

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 AM.