The New & Improved RANDARRAY Dynamic Array Function

Published: 08 February 2019
on channel: Excel On Fire (Oz du Soleil)

1,985

110

Lordy! This is a good one! Just within the past week the RANDARRAY function was improved! Dynamic Arrays, the functions and the new calculation engine just keep getting better.

RANDARRAY. WOW! This is better than both the old RAND and RANDBETWEEN functions!

This video shows 2 examples of using RANDARRAY. In the olden days, we would have needed more than just this one function. You will also see RANDARRAY used with INDEX and COUNTA! Everything you possibly could need ... it's all here, brothers and sisters. It's all here, and it's FIRE!

#DynamicArrays
#RANDARRAY
#ExcelFunctions

For more Excel and an intro to Get & Transform (Power Query) see my Lynda/LinkedIn courses:
https://www.linkedin.com/learning/ins...

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

My old blog: http://datascopic.net/blog-2-2

On this page of the site you can watch the video online The New & Improved RANDARRAY Dynamic Array Function with a duration of hours minute second in good quality, which was uploaded by the user Excel On Fire (Oz du Soleil) 08 February 2019, share the link with friends and acquaintances, this video has already been watched 1,985 times on youtube and it was liked by 110 viewers. Enjoy your viewing!

54,509