Nov 29 2022 06:36 AM
when I type "=RANDARRAY" it doesn't come up as a function in excel. I'm using Excel home and student 2019 if that impacts anything.
Nov 29 2022 06:40 AM
As far as I know the RANDARRAY function is only available in Excel for Microsoft 365 and Excel 2021. In Excel 2019, Excel 2016 and earlier versions, the RANDARRAY function is not available.
I don't know specifically about Excel home and student 2019, but it should be Excel 2019 (not available) as well.
Nov 29 2022 06:54 AM
I checked it again, it is what it is.
Feb 05 2023 06:06 PM
@Joe_Hudson I can say for sure that the RANDARRAY function USED to work in Excel 2019 because I own 2019 and I built a sheet that used the function quite significantly and now it is broken. I can't find the words to describe my frustration with this, especially as a user who just purchased 2019 not too long ago; now I have to upgrade again to access the features that were always there. I am beyond disappointed in this.