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, 12:08 PM

FreakMonster FreakMonster is offline

Windows 10 Generate Excel data list from complex matrix

Office 2016

Novice

Join Date: Dec 2019

Posts: 3

Quote:

Originally Posted by p45cal

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.

I was trying to do an array method before but it did not work. Thanks for correcting it.
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

« 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 03:18 AM.