RANDARRAY function in Excel | Better than RAND and RANDBETWEEN! | Excel Off The Grid

Подписаться 29 тыс.

Просмотров 5 тыс.

50% 1

★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ About this video ★
The RANDARRAY function creates and array of random numbers, in rows and columns, based on a minimum, maximum and whether it should return an integer or decimals.
In this video, we look a the new RANDARRAY function and how to master it with 4 examples.
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #ExcelOffTheGrid

Опубликовано:

5 дек 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@Up4Excel 2 года назад

I like your example of using the combination of SORTBY and RANDARRAY to create random sort orders in a single formula. Thanks Mark 👍

@ExcelOffTheGrid 2 года назад

Thanks 😀

@twseefeldt 3 года назад

Mark please keep the videos coming! you are gonna be big time. your content is easy to follow!

@ExcelOffTheGrid 3 года назад

Thanks Travis. I appreciate the support :-)

@DarrenAlderman 2 года назад

This is super cool. All these obscure formulas I've never used before can do so much!

@ExcelOffTheGrid 2 года назад

Thanks Darren. I'm glad you found it useful 😁

@wayneedmondson1065 3 года назад

Hi Mark. Great tips on using the new RANDARRAY function! Thanks for the video. Thumbs up!!

@ExcelOffTheGrid 3 года назад

Thanks Wayne 😀

@malakaideangelo6316 3 года назад

I know I am pretty randomly asking but do anybody know of a good site to watch new movies online?

@nicolaskorbyn6448 3 года назад

@Malakai Deangelo Try Flixzone. You can find it by googling =)

@westleytravis6538 3 года назад

@Malakai Deangelo Try FlixZone. Just search on google for it :)

@nsanch0181 3 года назад

Thank you for the rand array demonstrations. I enjoyed the video. If you ever run out of video ideas... it would be nice to see if rand array can be used to randomly generate a statistical process capability index like CpK. For example generate 150 values which will output a process capability greater than 1.67. Thanks for the video.

@ExcelOffTheGrid 3 года назад

Thank you. Being a finance guy myself, I might need to learn what some of those terms mean first. 😀

@ianl1052 2 месяца назад

Good way of picking my lottery numbers. Sadly, still only a 1 in 139,838,160 chance of winning the Euro Millions. 😒 Just need it to work for numbers, letters and special characters now for generating random passwords.

@RossMaynardProcessExcellence 3 года назад

Excellent video. Now I need to go and try creating an array of random dates using the DATE function in the place of the min and max numbers. I think it'll work. Will it? UPDATE: It worked - random dates all the way (format cells to date)!

@ExcelOffTheGrid 3 года назад

Good work. Dynamic Arrays are great aren't they.

@RossMaynardProcessExcellence 3 года назад

@@ExcelOffTheGrid Yes they are. If you're up for it, a video on the lambda function would be of interest. Make it understandable for halfwits like me!

@ExcelOffTheGrid 3 года назад

LAMBDA is a tricky one. Conceptually I love it. But will any normal person use it? It might just be one of those functions which Excel geeks use to confuse everybody else (yes, I’m guilty of that too). I’m waiting to see if anybody creates a strong use case for it first.

@RossMaynardProcessExcellence 3 года назад

@@ExcelOffTheGrid Interesting (and fair) point. I agree it needs to be useable in an everyday work situation to be of value. Alright, how about the use of # for spilling arrays. I haven't quite got my head round how to use that, and it does seem useful in a practical setting.

@ExcelOffTheGrid 3 года назад

Hi Ross - I did a presentation to the Toronto Excel meet-up group last year. Towards the end there is a section about advanced uses for spill ranges. But you might find the other content in the presentation interesting too. Check it out here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kyU702xwcxM.html