fbpx

All articles with 'randarray' Tag

Dynamic Arrays Live Masterclass – Replay

Published on Feb 23, 2021 in Learn Excel
Dynamic Arrays Live Masterclass – Replay

Excel Dynamic Array functions are going to change the way to you work your data forever. Watch the replay of the event here and learn about…

* What is so different about Excel’s dynamic array functions
* The new # operator
* 6 important dynamic array functions – FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
* 25 practical examples of dynamic array functions for business analysis
* Your questions & answers

Continue »

Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs

Published on Apr 6, 2020 in Learn Excel
Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs

Excel Dynamic Array Functions are a true game changer. These newly introduced DA functions can filter, sort, remove duplicates and do much more. The output of these functions can go to a range of cells. Hence the name – dynamic array functions.

Continue »

Make a random sentence with Excel formulas

Published on Jan 28, 2020 in Learn Excel
Make a random sentence with Excel formulas

Ever wanted to make a random sentence or text? You can use Excel formulas to make totally random sentences. This is a great way to generate test data or dummy data-sets.

Continue »