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.
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.
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.
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.
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).
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
love your content, this channel deserves way more attention than it gets! Thank you for the great content!
No kidding. I can't believe it is not more popular.
I agree, your videos/lessons are perfect. I've learned a ton from you. Thank you so much!
You did a fantastic job! The complex level is also adequate.
I am learning so much from this channel. Thanks a lot !
Very helpful, thanks for sharing 👍
Superb tutorial. Thank you. This sames me time compared to me figuring these out by myself.
Fabulous! This is very powerful content! Thanks so much for this video
Glad you enjoyed it!
23:32 Good Explanation Sir
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.
Muchas gracias por el video !! Saludos
Супер, ребята!
Hi.. thank you for this tutorial.. it help a lot..
If there is another date column.. how to sort by date?
Same way you sort numbers should work.
11:43
Can you please tell be me why A is before a but B is after b?
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.
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?
Then they ARE text in the spreadsheet.
How to sort multiple columns, sir?
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.
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.
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).
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.
🙏🏻