New RANDARRAY Function for Excel 365 - Excel Quickie 50

Опубликовано: 14 Январь 2025
на канале: TeachExcel

10,677

119

RANDARRAY() is the new Excel 365 function for generating random numbers - here, you'll learn how to use it to generate a large table of random numbers and then to freeze that table so you can better use it in the worksheet.

Excel Quickie 49: • Excel Coworker Prank - Broken Calcula...

This is one of my new favorite functions for Excel, it appears in the Excel 365 version of the program.

This function allows you to:
generate random decimal numbers in excel
generate random whole numbers in excel
generate a table of random numbers
make TeachExcel's life easier when going to make a table of random numbers for Excel tutorials :)

I know that this is a small function and maybe not useful to everyone, but I am really happy with it and wanted to share it with you guys!

Enjoy!

TeachExcel.com

#excel #tutorial #excelquickie