Forum Discussion
Solved
matrix formula in microsoft 365 online
Good morning,
I need to make matrix formula from function. For example, I have 17 values, average and some stdevp function. And I need make function norm.dist for every value. Microsoft 365 online shows me only first column, but it doesn't allow me make matrix function. I got only this advice https://support.microsoft.com/en-us/office/create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d
And it didn't help. My college gives only microsoft 365 online for their students, I can't download it to use it as a program. I tried function sort, but it doesn't show the next two columns what I need. Does anybody know how to do array formula in microsoft 365 online without using typical "Ctrl-Shift-Enter" or "CSE" formulas?
Thanks for tips.
Unfortunately I could not reproduce your problem. I also use Excel for the Web and have no problems creating a formula that displays all results in one row. The formula is only written in cell B23 and then spills over the row.
Perhaps you can explain your problem in more detail using the enclosed example file.
1 Reply
Unfortunately I could not reproduce your problem. I also use Excel for the Web and have no problems creating a formula that displays all results in one row. The formula is only written in cell B23 and then spills over the row.
Perhaps you can explain your problem in more detail using the enclosed example file.