Forum Discussion

Joe_Hudson's avatar
Joe_Hudson
Copper Contributor
Nov 29, 2022

=RANDARRAY function not working

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. 
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Nov 29, 2022

Joe_Hudson 

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.

 

 

  • Joe_Hudson's avatar
    Joe_Hudson
    Copper Contributor
    Nov 29, 2022
    Thank you
    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Nov 29, 2022

      Joe_Hudson 

      I checked it again, it is what it is.

      RANDARRAY function

      Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones.
       
      Nevertheless, I wish you a lot of fun and success with Excel.
       

Resources