Excel: How to randomly pick a number of items from a list using only 1 formula

preview_player
Показать описание
⚡⚡ This is a tutorial in Dynamic Array Excel, LET and LAMBDA ⚡⚡

00:00 Introduction
00:46 The Basic formulas in separate columns
03:17 Bringing it together in a single formula using LET
07:36 Naming the formula using LAMBDA
11:05 Storing your LAMBDAS in a GIST

🔢The Formula ( I realised I could AVOID the HSTACK by using SORTBY )

=LET(
SelectedList,B3:B12,
NumberOfItemsToReturn,4,
TAKE(
SORTBY(
SelectedList, RANDARRAY(ROWS(SelectedList))
),
NumberOfItemsToReturn,1
)

🖥️ My GIST

⏬Download my file

📕 BOOK
Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

( apologies to Tahlia for accidentally missing her name out 😩 )
  1. Access Analytic
  2. Excel
  3. Lambda
  4. Lamda
  5. Dynamic Arrays
  6. DA
Рекомендации по теме
How to Randomize 0:01:03

How to Randomize a List In Excel

Pick a Name 0:04:08

Pick a Name at Random from a List - Excel Formula

How to randomize 0:00:23

How to randomize data in Excel. #shorts #excel

random name generator 0:01:00

random name generator in excel |

How to Shuffle 0:00:49

How to Shuffle the Order of a List Randomly in Excel

Excel tip to 0:00:32

Excel tip to randomize lists

How to Randomly 0:05:25

How to Randomly Select a Winner for a Prize Giveaway Using Excel

How to Randomly 0:10:18

How to Randomly Assign Participants to Equal Sized Groups in Excel | Group Generator - No Repeats

advance excel formulas 0:13:00

advance excel formulas and functions|all excel formulas and functions| Day-2 |#excel #viralvideo

Microsoft Excel | 0:00:51

Microsoft Excel | How to Generate Random Numbers Within a Range

How to Create 0:07:12

How to Create Random Numbers in Excel (including no repeats)

Random sampling using 0:01:34

Random sampling using excel

Generate a Random 0:01:16

Generate a Random Value from a List in Excel

Select Random Winner 0:02:18

Select Random Winner With Excel RAND Function

Unique Random Number 0:06:17

Unique Random Number Generator in Excel - No Duplicates | Randomly Select Names in Excel

How to randomly 0:07:28

How to randomly assign people to different Teams using Excel

Excel - How 0:02:23

Excel - How to generate random lists to create pairs

How to randomly 0:00:39

How to randomly fill values from a list of data in Excel

Random Name in 0:00:55

Random Name in Excel #excel #exceltips #exceltutorial #msexcel #microsoftexcel #youtubeshorts #short

Random Selection from 0:05:10

Random Selection from a List in Excel & Google Sheets

Random Selection Without 0:07:14

Random Selection Without Replacement in Excel

Randomly Assign Names 0:09:17

Randomly Assign Names to Groups - Excel Formula

Create Random Student 0:05:38

Create Random Student Picker or Raffle Picker in Excel

Generate Random Dates 0:02:15

Generate Random Dates in Excel - EQ 85

Комментарии
Автор

Well very nice to see so many stuff in one video! as for the brackets, the last one should always be black...😉😉

barttitulaerexcelbart
Автор

Thanks for the video!. How about this one without a Lambda. =CHOOSEROWS(A1:A10, SORTBY(SEQUENCE(C1), RANDARRAY(C1)))

daXcel
Автор

Is there a way to add tooltips to parameters? Also, what's the easiest way to make a Lambda global?

brianxyz
Автор

Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

ExcelWithChris
Автор

The battle I've had to get the Advanced Formula Editor enabled in our corporate Excel....a year for them to say no....oh well, keep to the old method of adding LAMBDAs.... 😒😒

grahamc