Great video!! To avoid introducing wrong strings, a lambda W(w): =LAMBDA(w,TEXTJOIN("",,IFNA(XMATCH(SEQUENCE(7),w)^0,0))) =W({2,6,7}) will return 0100011
If the value ({2;6;7}) must be entered manually, to obtain the result of LAMBDA, why not insert it directly into the formula? =TEXTJOIN("",,IFNA(XMATCH(SEQUENCE(7),{2,6,7})^0,0)) 🤗
@@Excelambda Dear Exceλambda , OK! But even giving the name «Weekend» to LAMBDA, it is difficult to know what the «W» means for those who do not know the system. Only for those who know what it means. However, I forgot to say that I really liked your idea. 👍🤗
Thanks Mynda, this video was just-in-time for me, as I was working on some date calculations and you were magically there with the tutorial and the accompanying PDF! Super! 😊👍
Hi Mynda, Wht if i have list of days off and I want to calculate the difference? As the list get big its not fisiable to specify formula in each row. Thank in advance. 20-May-22 20-Jun-22 Mon, Tue 20-Mar-22 20-May-22 Wed, Thu 20-Jan-22 20-Apr-22 Sat, Sun 20-Nov-21 20-Mar-22 Mon, Tue, Wed 20-Sep-21 20-Feb-22 Fri, Sat, Sun 20-Jul-21 20-Jan-22 Sat, Sun, Mon 20-May-21 20-Dec-21 Tue, Wed, Thu
Not sure what you mean by 'calculate the difference'. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Not sure what you mean. Perhaps you can post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Hi Catherine, I've been asked this question before. Please see this post (change the 3 to 5 for your needs): www.myonlinetraininghub.com/excel-forum/excel/how-do-i-easily-set-the-date-to-show-3-times-then-move-on-to-the-next-3#p11280
Mynda, are you serious? how does it happen? I haven't seen before this type of formula "01100..." 🤯 very screet tip and it is so useful I think. Does it work in Aggregate and Subtotal functions because sub functions are being used same type of syntax like (...)1-Average , (...)2-Count etc...?