Forum Discussion
Solved
Matrix with Three Axes
I would like to create a spreadsheet that allows me to matrix three data sets (3 dimensional capability). A two-dimensional matrix is easy. It has a horizontal axis and a vertical axis. >> I...
If all you require is to collect data then a common practice is simply to repeat the block of data.
The spreadsheet is probably better than any other software for representing such data.
It gets complicated if you want to perform calculations based upon data held in such formats. The methods I showed were aimed at supporting such calculation and demonstrated new functionality emerging within Excel 365.
The other strategy for storing data is to place it within a single column and then add fields to describe the remaining attributes. Such database tables form a good basis for subsequent calculation.
Afraid not, but yo may use INDEX without lambdas as PeterBartholomew1 mentioned.
OK FOLKS.
It's looking to me like Excel is not really a good tool to use for this.
>> Any recommendations for some other tool ???
It's looking to me like Excel is not really a good tool to use for this.
>> Any recommendations for some other tool ???