We are trying to sort rows in numerical order (we have about 70 rows with these type numbers). We know that's doable in numerical order, however, the numbers are unusual and we have a special requirement. Her is an example of a column and each number is in a row: 2-6-0 2-10-2 2-6-2 4-8-2 4-4-2 2-8-2 2-8-4 2-6-4 2-8-0 0-6-0 2-10-0 The problem: The focus is on getting the middle number(s) all grouped together and then sorted in order with the first digit (and last digit) then being numerically sorted. We are trying to sort them like this in the column as an example: 4-4-2 0-6-0 2-6-0 2-6-2 2-6-4 2-8-0 2-8-2 2-8-4 4-8-2 2-10-0 2-10-2 Normal numerical sorting would not group these correctly like shown because it would use the first number as the sorting point.These numbers by the way are railroad steam engine designations for their wheel arrangements, for which I have about 70 vintage brass models of these in HO scale and I need to sort them correctly to find them easily on a spread sheet. There are 12 columns in our spread sheet (one column with the numbers above) and the other columns with other data like: manufacturer, whether factory painted, condition, w/original box, etc). Thanks and hoping there is a way to sort them. Thanks. Philip
sir i have a problem in sorting the data.when i sort the data by date.it sort the data by date but it doesn't take care of month.like if the dates are 21.3.2018 or 20.4.2018.it will put 20.4.2018 first and then 21.3.2018.if you have any solution regarding this kindly tell me about.
I’m looking for a way to quickly rearrange this into order of dates oldest to newest how do I go about this timeline settings disney animated canon "Fantasia: Rite of Spring 65,000 BCE " "Fantasia 2000: Pomp and Circumstance 1800 BCE Firebird Suite 1590 BCE " Fantasia: The Pastoral Symphony) 1277 BCE brother bear 10,000 bc Atlantis The Lost Empire 7000 BC The Lion King 1178 bce Hercules 1179 bce Moana 984 bce The Sword In The Stone 400s Mulan 500s fantasia the sources apprentice 740 fantasia night on bald moutian 1025 The Black Cauldron Dark Ages Aladdin 800s Robin Hood 1194 Sleeping Beauty 1300s The Hunchback Of Notre Dame 1482 The Emperor's New Groove -1500 Snow White And The Seven Dwarfs early 1500s Pocahontas 1607 Fun and Fancy Free: Mickey and the Beanstal 1734 Beauty & The Beast 1770s The Adventures of Ichabod 1790 Melody Time: The Legend of Johnny Appleseed 1795 Tangled 1820 Frozen 1820 Frozen 2 1823 Melody Time: Pecos Bill 1858 Alice In Wonderland 1862 Fantasia 2000 the steadfast tin soldier Cinderella mid 1860s Tarzan mid 1882 Pinocchio 1883 Make Mine Music: The Martins and The Coys 1885 Make Mine Music: The Whale Who Wanted to Sing at the Met 1886 make mine music casey at the bat 1888 make mine music johny fedora and alice bluebonnet 1889 melody time once upon a wintertime 1890 fantasia nutcraker 1892 Home On The Range mid 1875s fantasia dance of the hours 1876 The Jungle Book 1893 The Little Mermaid mid 1890s Basil The Great Mouse Detective 1897 Peter Pan 1900 Mr Toad 1906 Lady & The Tramp 1908 The Aristocats 1910 Atlantis The Lost Empire 1914 The Many Adventures Of Winnie The Pooh 1926 Winnie The Pooh 1926 fantasia 200 RHAPSODY BLUE 1932 make mine music Peter and the wolf 1936 "make mine music blue bayou 1936 " Dumbo 1941 fun and fancy free bongo 1941 Saludos Amigos 1942 The Three Caballeros 1944 make mine music all the cats join in 1946 melody time little toot 1948 Bambi 1942 fantasia 2000 pines of rome 1924 101 Dalmatians 1961 Rescuers 1-2 1970s The Fox & The Hound 1981 Oliver & Company 1988 "Fantasia 2000: The Carnival of the Animals 1999 " Lilo & Stitch 2002 Chicken Little 2002 Meet The Robinsons 2007 Bolt 2008 Super Rhino 2008 Wreck-It Ralph 2012 Big Hero 6 2014 Zootopia 2016 Wreck-It Ralph 2 2018 Meet The Robinsons 2037 Treasure Planet 10000000000000000000...
I am very new novice in excel, i made one randomly generated list of dates between 2 dates, ( one and half year total ), but when i sort the dates it is a bit sorted but not exactly and precisely and having wrong dates in between.. i tried this method it wont working at all
I bet the 33 people that disliked this video are Americans...hehehe...just cos you said you write the dates the "right" way...lol...nice vid btw, thanks for sharing this :)
![Google Sheets - How to Sort Dates into Chronological Order [Updated]](/img/n.gif)
Very simple way of teaching no hurry ❤
Thank you so much 🙂
Thanks for the explanation. Very clear 👌🏽 and accurate
Thank you..saved a lot of manual work for me
Perfect thank you. New to using Excel and this is short but sweet. Very easy to follow. 😊
You're very welcome!
Thank you so much! Had to laugh at putting the dates in the "right order" :-D
Thank you. Clear. Concise. Accurate.
Superb! Thanks, this is really helpful.
this literally saved me HOURS of sorting through mixed data!!!!!!!!!
I am so glad! Have fun with those extra free hours!
Awesome clarification 👍and thank you so much for your very valuable sharing.
Glad it was helpful!
@@TheTechTrain sorry if "A to z" option is displaying instead of "oldest to newest" i can sort by "a to z" and i get the same result?
Thank you!!!
You're welcome!
Thank you, it was really helpful 😃 definite thumbs up for me !
Thank you for being through.
Great Job, very informative, love the jab about the dates!
Thank u .....very use ful information
Thanks
So helpful-- thanks so much!!!
what happens when the year of birth are also different and u want to sort from either oldest to youngest or vice versa??? this doesn't work..
Thanks for this excellent video
Verry helpful sir
We are trying to sort rows in numerical order (we have about 70 rows with these type numbers). We know that's doable in numerical order, however, the numbers are unusual and we have a special requirement. Her is an example of a column and each number is in a row:
2-6-0
2-10-2
2-6-2
4-8-2
4-4-2
2-8-2
2-8-4
2-6-4
2-8-0
0-6-0
2-10-0
The problem: The focus is on getting the middle number(s) all grouped together and then sorted in order with the first digit (and last digit) then being numerically sorted. We are trying to sort them like this in the column as an example:
4-4-2
0-6-0
2-6-0
2-6-2
2-6-4
2-8-0
2-8-2
2-8-4
4-8-2
2-10-0
2-10-2
Normal numerical sorting would not group these correctly like shown because it would use the first number as the sorting point.These numbers by the way are railroad steam engine designations for their wheel arrangements, for which I have about 70 vintage brass models of these in HO scale and I need to sort them correctly to find them easily on a spread sheet. There are 12 columns in our spread sheet (one column with the numbers above) and the other columns with other data like: manufacturer, whether factory painted, condition, w/original box, etc). Thanks and hoping there is a way to sort them. Thanks.
Philip
MARVELOUS! THANKS!
sir i have a problem in sorting the data.when i sort the data by date.it sort the data by date but it doesn't take care of month.like if the dates are 21.3.2018 or 20.4.2018.it will put 20.4.2018 first and then 21.3.2018.if you have any solution regarding this kindly tell me about.
How do one put the date including, day, week, month and year/solar year count in chronological order?
Thank you sir ❤️😘👏🏼👏🏼👌🏼
You're very welcome! I'm glad it was useful.
Thank you so much!
Thank you so much. Very helpful.
YOU'RE A LIFESAVER
I'm so glad you found it useful!
THANK YOU SO MUCH
THANK U BRO HAVE NICE DAY
Thank you, you too!
Great Video. Helped me a lot :)
Thanks Julia, I'm so glad!
Thank you very much. very helpful (y)
You're welcome! Thanks for your comment. (Don't forget to subscribe! 😉)
Thanks for subscribing! 👍
+The Tech Train no probs 👍🏻
Thank you!!!! LIFE SAVER!
I’m looking for a way to quickly rearrange this into order of dates oldest to newest how do I go about this
timeline settings
disney animated canon
"Fantasia: Rite of Spring 65,000 BCE
"
"Fantasia 2000: Pomp and Circumstance 1800 BCE
Firebird Suite 1590 BCE
"
Fantasia: The Pastoral Symphony) 1277 BCE
brother bear 10,000 bc
Atlantis The Lost Empire 7000 BC
The Lion King 1178 bce
Hercules 1179 bce
Moana 984 bce
The Sword In The Stone 400s
Mulan 500s
fantasia the sources apprentice 740
fantasia night on bald moutian 1025
The Black Cauldron Dark Ages
Aladdin 800s
Robin Hood 1194
Sleeping Beauty 1300s
The Hunchback Of Notre Dame 1482
The Emperor's New Groove -1500
Snow White And The Seven Dwarfs early 1500s
Pocahontas 1607
Fun and Fancy Free: Mickey and the Beanstal 1734
Beauty & The Beast 1770s
The Adventures of Ichabod 1790
Melody Time: The Legend of Johnny Appleseed 1795
Tangled 1820
Frozen 1820
Frozen 2 1823
Melody Time: Pecos Bill 1858
Alice In Wonderland 1862
Fantasia 2000 the steadfast tin soldier
Cinderella mid 1860s
Tarzan mid 1882
Pinocchio 1883
Make Mine Music: The Martins and The Coys 1885
Make Mine Music: The Whale Who Wanted to Sing at the Met 1886
make mine music casey at the bat 1888
make mine music johny fedora and alice bluebonnet 1889
melody time once upon a wintertime 1890
fantasia nutcraker 1892
Home On The Range mid 1875s
fantasia dance of the hours 1876
The Jungle Book 1893
The Little Mermaid mid 1890s
Basil The Great Mouse Detective 1897
Peter Pan 1900
Mr Toad 1906
Lady & The Tramp 1908
The Aristocats 1910
Atlantis The Lost Empire 1914
The Many Adventures Of Winnie The Pooh 1926
Winnie The Pooh 1926
fantasia 200 RHAPSODY BLUE 1932
make mine music Peter and the wolf 1936
"make mine music blue bayou 1936
"
Dumbo 1941
fun and fancy free bongo 1941
Saludos Amigos 1942
The Three Caballeros 1944
make mine music all the cats join in 1946
melody time little toot 1948
Bambi 1942
fantasia 2000 pines of rome 1924
101 Dalmatians 1961
Rescuers 1-2 1970s
The Fox & The Hound 1981
Oliver & Company 1988
"Fantasia 2000: The Carnival of the Animals 1999
"
Lilo & Stitch 2002
Chicken Little 2002
Meet The Robinsons 2007
Bolt 2008
Super Rhino 2008
Wreck-It Ralph 2012
Big Hero 6 2014
Zootopia 2016
Wreck-It Ralph 2 2018
Meet The Robinsons 2037
Treasure Planet 10000000000000000000...
I am very new novice in excel, i made one randomly generated list of dates between 2 dates, ( one and half year total ), but when i sort the dates it is a bit sorted but not exactly and precisely and having wrong dates in between.. i tried this method it wont working at all
I am having a data where its mention like month,day.year and i am unable to clean it up. with this formula eg :
12/16/1980
But if you add a new date you have to keep resorting every entry...?? How do you auto sort as you add a selection?????????????
VERY GOOD
Thank You
You're very welcome!
Mine is not giving me an option to expand the selection, this is so frustrating
thanks
+Bakri Widjaja you're welcome! (Don't forget to subscribe if you haven't already! 👍)
My data does not have any option? Why is that
I bet the 33 people that disliked this video are Americans...hehehe...just cos you said you write the dates the "right" way...lol...nice vid btw, thanks for sharing this :)
It didn’t really work ☹️💔
Feel free to email the file to me and I'll take a look.
tx bro, but ur talking too damn slow...
Thank you
+Revelation612 You're very welcome! (Don't forget to subscribe if you haven't already! 😉)