Excel Challenge -Is the string sorted??
HTML-код
- Опубликовано: 4 окт 2023
- is the string sorted excel? In this Excel challenge, we filter out strings that are sorted(i.e the characters of the string/word are in alphabetical order). Sort the string alphabetically and compare with the string itself to know if it is sorted or not
Workbook link: docs.google.com/spreadsheets/...
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
Very nice video
Thabks for your feedback. Very much appreciated
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
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.
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.