Forum Discussion
SilverStat
Feb 24, 2023Copper Contributor
Iterating a lambda function over an array
Hello, I have added what I hope is a simplified version of the problem I am having here. Take this pair of matrices: The function I need is expected to behave as follows: Suppose I am inte...
Harun24HR
Feb 24, 2023Bronze Contributor
Share a sample workbook (attach file to your post) with desired output. REDUCE() function may help with VSTACK().
- SilverStatFeb 24, 2023Copper ContributorThank you for the quick reply Harun. Pardon the simple question, but how does one attach an Excel file? I tried and it said that the excel file type was not supported, or that I could not attach it anyway. Thanks again,
- FikturFoxFeb 24, 2023Brass ContributorLooks like MAP() function is what you are looking for.
A screenshot of the data with the expected result will be fine if you can't attach the file.- SilverStatFeb 24, 2023Copper ContributorI have attached screenshots. If more is required, please let me know. A bit annoying I cannot seem to add the worksheet itself. Thanks igorot.