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

No video

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

Рет қаралды 2,326

Access Analytic

Күн бұрын

Пікірлер: 16

@chrism9037 5 ай бұрын

Thanks Wyn, this is a great video!

@AccessAnalytic 5 ай бұрын

Cheers Chris

@barttitulaerexcelbart9400 5 ай бұрын

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

@AccessAnalytic 5 ай бұрын

Cheers, and good tip!

@daXcel7448 3 ай бұрын

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

@AccessAnalytic 3 ай бұрын

Nice one. Another option: =TAKE( SORTBY(A1:A10,RANDARRAY(ROWS(A1:A10) ) ), C1)

@yulinliu850 5 ай бұрын

❤❤

@brianxyz 5 ай бұрын

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

@AccessAnalytic 5 ай бұрын

No to tooltips. You could share centrally held Excel templates and set up to open by default when opening excel ( there’s a templates file path under file - options - ( advanced I think

@grahamc5531 5 ай бұрын

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.... 😒😒

@AccessAnalytic 5 ай бұрын

😩 why no?

@grahamc5531 5 ай бұрын

No reason given, just no - I assume they think because it is an add-in there may be a security risk....even though it comes from MS themselves...here's hoping it gets added as a standard button at some point so everyone gets it

@ExcelWithChris 5 ай бұрын

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.

@AccessAnalytic 5 ай бұрын

I think I saw Chandeep ( Goodly KZfaq channel ) do that a while back. Not sure I’d recommend it from a process understandability point of view.

@ExcelWithChris 5 ай бұрын

Think that is where I also saw it, but cannot find the video again. Left comment on one of his videos as well, but he seldom comes back. Do you by any chance know how to do it? (as a in between step and then carry on)@@AccessAnalytic

@AccessAnalytic 5 ай бұрын

@ExcelWithChris kzfaq.info/get/bejne/rcuRmdN4l9-rYas.htmlsi=mcjxVeA7uAUeu7Na