love your content, this channel deserves way more attention than it gets! Thank you for the great content!
@ronturnbull27862 жыл бұрын
No kidding. I can't believe it is not more popular.
@XynethaGrows2 жыл бұрын
I agree, your videos/lessons are perfect. I've learned a ton from you. Thank you so much!
@michaelshaw76523 жыл бұрын
You did a fantastic job! The complex level is also adequate.
@johanrusli4 жыл бұрын
I am learning so much from this channel. Thanks a lot !
@JohnBenRodriguez2 жыл бұрын
Superb tutorial. Thank you. This sames me time compared to me figuring these out by myself.
@travisgillespie28193 жыл бұрын
Very helpful, thanks for sharing 👍
@evandawson10374 жыл бұрын
Fabulous! This is very powerful content! Thanks so much for this video
@ExcelGoogleSheets4 жыл бұрын
Glad you enjoyed it!
@marutigroupofcompanies63632 жыл бұрын
23:32 Good Explanation Sir
@Александр-ы4в6к5 жыл бұрын
Супер, ребята!
@phoenixempire88864 жыл бұрын
🙏🏻
@halcook17883 жыл бұрын
Love this. How can I set the sort to run on a date column? My date field is displayed as "Fri, Apr 9, 2021". Using what is demonstrated in your [AWESOME] video, my sheet sorts with blanks on top, then day of week as text. Would love to know if you already have this in another video.
@czengineeringideas2 жыл бұрын
Can I ask why why is this done so complicated? Couldnt it be done just with single callback function in function sort? Is it because of procesor usage or just for educational purposes so you could show us more functions? Thank you. By the way the channel is really great. I didnt find better source for this topic (usage of javascript in google sheets).
@ExcelGoogleSheets2 жыл бұрын
for educational purposes , but sure, you can put the same function in parenthesis. I'm not sure how it makes it any more or less complicated.
@paulloup52105 жыл бұрын
Muchas gracias por el video !! Saludos
@RoseLK4 жыл бұрын
How to sort multiple columns, sir?
@groygroy12553 жыл бұрын
This is a great video! Thanks so much. I am looking for this as well. I need to sort an array by multiple columns. Hoping you already have a video on that.
@ronturnbull27862 жыл бұрын
Boss: Could you sort this list of alphanumeric items for me by noon? Me: Sure Boss ... No problem! Noon it is. I'll use this handy-dandy JavaScript routine to solve the problem. --------- 3 days later ---------------------- Me: Here you go, Boss. It's all sorted ... well, sort of. Boss: I thought you said you would have it done by noon. Me: You didn't say on which day.
@ruhulqudus9972 жыл бұрын
Hi.. thank you for this tutorial.. it help a lot.. If there is another date column.. how to sort by date?
@ExcelGoogleSheets2 жыл бұрын
Same way you sort numbers should work.
@marekcech73654 жыл бұрын
thanks for the video, I have a problem that data from sheet are not loaded as numbers but as a text, some workaround for this?
@ExcelGoogleSheets4 жыл бұрын
Then they ARE text in the spreadsheet.
@032umeshverma83 жыл бұрын
11:43 Can you please tell be me why A is before a but B is after b?
@ronturnbull27862 жыл бұрын
Sure. Since the algorithm has been modified to convert everything to lowercase, then A=a and B=b. Therefore, it treats them as being equal and the function returns "0", which means that the order of the items is not changed. So it really depends on the physical location of the items in the array. As it is, this will always be the case when implementing this solution. You would need to look at the ASCII values of the items and compare them instead.