Well very nice to see so many stuff in one video! as for the brackets, the last one should always be black...😉😉
@AccessAnalytic5 ай бұрын
Cheers, and good tip!
@daXcel74483 ай бұрын
Thanks for the video!. How about this one without a Lambda. =CHOOSEROWS(A1:A10,SORTBY(SEQUENCE(C1), RANDARRAY(C1)))
@AccessAnalytic3 ай бұрын
Nice one. Another option: =TAKE( SORTBY(A1:A10,RANDARRAY(ROWS(A1:A10) ) ), C1)
@yulinliu8505 ай бұрын
❤❤
@brianxyz5 ай бұрын
Is there a way to add tooltips to parameters? Also, what's the easiest way to make a Lambda global?
@AccessAnalytic5 ай бұрын
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
@grahamc55315 ай бұрын
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.... 😒😒
@AccessAnalytic5 ай бұрын
😩 why no?
@grahamc55315 ай бұрын
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
@ExcelWithChris5 ай бұрын
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.
@AccessAnalytic5 ай бұрын
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.
@ExcelWithChris5 ай бұрын
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