Forum Discussion
Re-ordering spreadsheet
Hi, I'm new to the forum and hope this question makes sense. I have a spreadsheet with financial information that I use to prepare my tax return. The rows are different securities. The columns are di...
Hi Riny
If you are getting involved with Lambda functions, would you like to see some utilities I have experimented with? One reads a data item from an arbitrary representation of a multidimensional array, using the Lambda function
= DATAλ(iᵣ)
which takes as its argument an array of indices, iáµ£ (in hindsight, I probably should have used separate parameters for each dimension but that would mean additional steps in the calculations).
To be able to read a value back from any layout of data is useful, but I have also written functions that generate row and column arrays of such indices to allow the data to be repivoted (or aggregated by addition) at will. One option is to create a pivot-table normalised form of the users data.
I have made a start with putting the Lambda functions up on GitHub as Gists but the process is completely alien to me (I have received some advice but I don't think my advisor realises the level of profound ignorance I can bring to the table).
I have also attached the workbook that demo's the functions, though I would not claim to have got to the point of the workbook being self-evident.
PeterBartholomew1 Will study with great interest!!