Hello,
Most of the functions used by you are array functions which are computed in a different way in Excel, however they cannot be computed in the same way in Spread. Spread has same functions which accept array as a parameter and even return an array, however the array returned is not displayed directly in Spread as is the case in Excel. In Spread if you want to display this array you would need to access each element of the Array and display it using the Index function, which is meant to return an element in an array. However in the formula specified by you, you are simply passing the arrays returned by functions as parameters to functions and finally return a single value so this can be done directly using the same formula. But the formula specified by you is not working even in Excel at my end, the issue is with the parameters passed to the Frequency function. So, I just changed these parameters to two cell ranges in the sheet and it made the formula to work in both Excel ads well as Spread. The formula used by me was :
=MAX(FREQUENCY(ROW(A1:A10),ROW(B1:B4)))
So, in case you want to return a single value from a formula, you can apply the formula directly as you do in Excel and if you want to return an array then you would need to take the help of the Index function. I am attaching a sample depicting how I used the above formula and the Index function, kindly have a look at the same. Hope it will help you. Please let me know if you have any queries further.
Thanks,
Manpreet KAur. |
陕公网安备：61019002000258 |
隐私政策 |
网站地图