What makes your explanation excellent is that you are able to solve these cases, step by step, with overwhelming logic, so that anyone can appreciate each process in detail until reaching the final solution. Thank you Victor!!
Another masterclass Victor. I've done about 50 of these now and it has really opened my eyes to lambdas etc and the mid/sequence formula is now a firm favourite when solving these types of issues. I would like to see you do some more challenging ones as it's great to see how your mind thinks. Cheers Steve
Thank you, Steve, for your feedback. The MID/SEQUENCE is great. If you have specific challenges you want to point ne to, I will be more than happy to showcase my approach
Victor... i blew a coworker;s mind 2 weeks ago with that construct. I told him about your channel for him to subscribe. Man.. thanks for sharing all those tricks on your channel.
Victor Victor Victor My Role Model You are Amazing !! You really should come up with an advanced course on excel formulas. I Swear it would be a bestseller some of us crave your instruction and depth of knowledge.
Thank you so much for the feedback. It is something i definitely have thought about, mow that you have mentioned, maybe I should put in some more effort in that direction
Hi Victor. I was trying to follow your logic on breaking the words apart by using the MID , SEQUENCE and LEN constructor however, i cannot get it to spill down in one formula getting a #CALC error. This is the formula i am using ( This work in one cell but it does not spill down) TRANSPOSE(MID(Y8,SEQUENCE(LEN(Y8),,1),1)) . Then when I try to use the MAP lambda helper function i got a #CALC error MAP(Y8:Y18,LAMBDA(x,TRANSPOSE(MID(x,SEQUENCE(LEN(x),,1),1)))). What am i doing wrong? Thanks in advance
Hello Luis. The first question would be what you have in Y8 as at when you evaluated the formula, but i see that in your case, you are trying to transpose the characters, i.e have it spill horizontally instead of vertically. in that case, I would use =MID(A1,SEQUENCE(,LEN(A1)),1) which uses LEN(A1) as the column argument of the sequence and not as the row argument. For the MAP, it doesn't work because your MAP returns multicolumn-multirow Array, if you add a CONCAT over the transpose to glue it together again, it should work, as your result is now 1 column by N rows. MAP cannot return a 2-D array from a 1-D input
Hi Victor... I think i got it. I was not using the MID SEQUENCE LEN correctly since i am trying to spill to the right for each word. I will try that tomorrow at the office. Thanks again Victor.
What makes your explanation excellent is that you are able to solve these cases, step by step, with overwhelming logic, so that anyone can appreciate each process in detail until reaching the final solution. Thank you Victor!!
Your comment deserves a PIN. I appreciate your feedback on the video and other videos and comments like this encourage us to continue
Another masterclass Victor. I've done about 50 of these now and it has really opened my eyes to lambdas etc and the mid/sequence formula is now a firm favourite when solving these types of issues. I would like to see you do some more challenging ones as it's great to see how your mind thinks. Cheers Steve
Thank you, Steve, for your feedback. The MID/SEQUENCE is great. If you have specific challenges you want to point ne to, I will be more than happy to showcase my approach
@@ExcelMoments hi Victor, how about the new challenge 300?
@@stevereed5776 okay, sounds like ab interesting one
Good morning, Victor. Nice explanation and that formula construct of MID with SEQUENCE and LEN it's a killer! to break apart each word! Love it...
Probably the most recurring construct in my Arsenal 😁😁😁😁
Victor... i blew a coworker;s mind 2 weeks ago with that construct. I told him about your channel for him to subscribe. Man.. thanks for sharing all those tricks on your channel.
Victor Victor Victor My Role Model You are Amazing !! You really should come up with an advanced course on excel formulas. I Swear it would be a bestseller some of us crave your instruction and depth of knowledge.
Thank you so much for the feedback. It is something i definitely have thought about, mow that you have mentioned, maybe I should put in some more effort in that direction
Very nice video
Thabks for your feedback. Very much appreciated
Hi. Here's another way to solve the question
=LET(rng,A2:A10,FILTER(rng,BYROW(rng,LAMBDA(rw,AND(DROP(MID(rw,SEQUENCE(LEN(rw)),1),-1)
Hi Victor. I was trying to follow your logic on breaking the words apart by using the MID , SEQUENCE and LEN constructor however, i cannot get it to spill down in one formula getting a #CALC error. This is the formula i am using ( This work in one cell but it does not spill down) TRANSPOSE(MID(Y8,SEQUENCE(LEN(Y8),,1),1)) . Then when I try to use the MAP lambda helper function i got a #CALC error
MAP(Y8:Y18,LAMBDA(x,TRANSPOSE(MID(x,SEQUENCE(LEN(x),,1),1)))). What am i doing wrong? Thanks in advance
Hello Luis. The first question would be what you have in Y8 as at when you evaluated the formula, but i see that in your case, you are trying to transpose the characters, i.e have it spill horizontally instead of vertically. in that case, I would use =MID(A1,SEQUENCE(,LEN(A1)),1) which uses LEN(A1) as the column argument of the sequence and not as the row argument. For the MAP, it doesn't work because your MAP returns multicolumn-multirow Array, if you add a CONCAT over the transpose to glue it together again, it should work, as your result is now 1 column by N rows. MAP cannot return a 2-D array from a 1-D input
Hi Victor... I think i got it. I was not using the MID SEQUENCE LEN correctly since i am trying to spill to the right for each word. I will try that tomorrow at the office. Thanks again Victor.