The New & Improved RANDARRAY Dynamic Array Function

Опубликовано: 08 Февраль 2019
на канале: 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


На этой странице сайта вы можете посмотреть видео онлайн The New & Improved RANDARRAY Dynamic Array Function длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Excel On Fire (Oz du Soleil) 08 Февраль 2019, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 1,985 раз и оно понравилось 110 зрителям. Приятного просмотра!