Excel Won't Sort Dates Correctly - The Solution!

Excel Won't Sort Dates Correctly - The Solution!

The Tech Train

8 лет назад

601,204 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

 Busniess Books Summaries
Busniess Books Summaries - 11.09.2023 14:12

Great explanation. Thx

Ответить
Maria Andrades
Maria Andrades - 23.08.2023 17:05

That was it! Very useful, thank you!

Ответить
Souvik Das
Souvik Das - 19.08.2023 23:00

Exactly what I was looking for thanks 🙏

Ответить
Bawandar
Bawandar - 12.08.2023 09:04

Anyone watching in 2023

Ответить
Sandeep Harchand
Sandeep Harchand - 05.08.2023 11:46

Very Helpful

Ответить
Mechanism of Technology Pty Ltd
Mechanism of Technology Pty Ltd - 02.08.2023 18:57

I know you did this video 7 years ago but THANK YOU.

Ответить
Keenan King
Keenan King - 28.07.2023 19:14

7 years later and this still saved my ass 😂

Ответить
Jacob Koshy
Jacob Koshy - 24.07.2023 10:41

Wow thankyou sir it was extremely helpful 🎉

Ответить
shubham vashistha
shubham vashistha - 20.07.2023 13:18

Thanks 🙏

Ответить
Eva Yi
Eva Yi - 15.07.2023 06:47

Thank you for sharing, this solved my issue.

Ответить
Pankaj Chauhan
Pankaj Chauhan - 13.07.2023 21:01

Very helpful and to the point. Thankyou so much

Ответить
Eyinade Adewale David
Eyinade Adewale David - 28.06.2023 19:29

What can I do if have dates and I wrote different description to each date, how can I maintain each description without loosing the date after I have sorted the date to be in order AZ

Ответить
Irfan Bhat
Irfan Bhat - 13.06.2023 00:21

Thank you so much ❤️

Ответить
Jordan Hanna
Jordan Hanna - 09.06.2023 07:41

Lifesaver thankyou !!

Ответить
Vaibhav Garg
Vaibhav Garg - 31.05.2023 11:40

wow

Ответить
Epson Training
Epson Training - 17.05.2023 08:31

I have a raw data format in this order. How can i sort it properly

CreatedDate
12/6/2022 1:38:03 pm
12/23/2022 1:29:45 PM
1/26/2023 9:55:04 AM
1/27/2023 4:14:52 PM

Ответить
Davina Hopley
Davina Hopley - 16.05.2023 10:00

Thank you. This video was really helpful after I had been struggling for the past two days😅

Ответить
DEVESH UPRETI
DEVESH UPRETI - 09.05.2023 21:56

how to convert mm-dd-yyyy format to m-d-yy format, anyone can give us formula ??

Ответить
Raphael C
Raphael C - 01.05.2023 00:11

you saved my day.thank you

Ответить
Oops Highlights
Oops Highlights - 28.04.2023 23:21

Thank you so much! Fixed my issue still in 2023, wonderful!

Ответить
Andrea Attempts
Andrea Attempts - 28.04.2023 07:10

THANK YOU! THANK YOU!! THANK YOU!!!!!!! 🎉🎉🎉

I was losing my mind trying to get this working - add in a bunch of data lost and I just needed something to work right about now.

Ответить
Kushal Khade
Kushal Khade - 24.04.2023 12:59

Thank you ...

Ответить
KTS717
KTS717 - 20.04.2023 01:00

Amazing! It was driving me nuts! Thank you!

Ответить
Narang Express
Narang Express - 13.04.2023 10:46

THANKS A LOT SIR

Ответить
Shounakp
Shounakp - 11.04.2023 12:53

Awesome...my excel is sorted now...thx a ton..

Ответить
Phinda Magagula
Phinda Magagula - 07.04.2023 15:20

Helped me, thank you so much

Ответить
Alexa Flynn
Alexa Flynn - 04.04.2023 20:31

This helped me a lot. Thank you!

Ответить
Dr. Sigal Levy
Dr. Sigal Levy - 02.04.2023 00:55

How do you sort a column of date from old to new without the columns nearby which have numbers and names together. When I sorted the dates, it sorted from small to large on the column of name and number.

Ответить
Paleto
Paleto - 20.03.2023 19:17

AWESOME!!! FINALLY, an easy solution to a problem I get every time a client sends me their Excel file.

Ответить
Dagmar Edwards
Dagmar Edwards - 20.03.2023 02:23

Absolutely great! Thanks

Ответить
Melvin Rijlaarsdam
Melvin Rijlaarsdam - 07.03.2023 00:00

Awesome, googling for half an hour didn't give me a solution, this video hit the spot!

Ответить
gul rukh
gul rukh - 04.03.2023 21:58

Finally... Strategy that work... Thank you man

Ответить
Rasmi Omar
Rasmi Omar - 02.03.2023 19:05

thx a lot.

Ответить
Priya Kalas
Priya Kalas - 02.03.2023 12:18

How to convert date from Aug 30, 2021 11:20:05 AM to 30-08-2021.. this is in text format too

Ответить
Devaraju Ac
Devaraju Ac - 27.02.2023 18:27

Thank u ,

Ответить
hd
hd - 26.02.2023 11:34

I wonder how you would solve the problem with the first column. I can't solve it for counts this way.🙏

Ответить
Rahul Parmar
Rahul Parmar - 25.02.2023 20:15

You're a saviour!!👑

Ответить
Agha Tires
Agha Tires - 25.02.2023 12:31

THE BESTTTTTT

Ответить
Madhuri Devkate
Madhuri Devkate - 24.02.2023 08:41

After so many effort I found this video and it's really works .Thanks a loooot👍

Ответить
Ashish Kumar
Ashish Kumar - 20.02.2023 19:34

Worked for me👍thanks

Ответить
Cordy One
Cordy One - 08.02.2023 18:50

my text to columns options are not the same as this at all

Ответить
Eugene Arvin Lim
Eugene Arvin Lim - 06.02.2023 05:06

Thank You So Much!!

Ответить
HASHVAPAHAKAN GRASENYAK
HASHVAPAHAKAN GRASENYAK - 29.01.2023 20:47

Thak you very much.With your tutorial I have solution .

Ответить
Afshin Nikravesh
Afshin Nikravesh - 27.01.2023 17:50

Tadda ! My problem goes away. Thank you so much. It was really amazing. Thank you so much again :))

Ответить
mso2802
mso2802 - 26.01.2023 16:51

this is super useful! thank you so much!

Ответить
Stephen Walker
Stephen Walker - 26.01.2023 11:23

This helped so much thank you!

Ответить
Cherag Bhatia
Cherag Bhatia - 18.01.2023 11:38

Amazing video saved 2 hours of manual work!!!

Ответить
nikkie253
nikkie253 - 18.01.2023 02:46

Thank you, I was going crazy trying to figure out why my dates were sorting by months and years! And now I have the new tool of knowing when to check if the field is True or False for text!

Ответить