God bless you I refer to this video every semester when I put all my class assignments into sheets and then order them by date
@kale6264
Жыл бұрын
I’m doing that rn lollll
@cr7neymar908
Жыл бұрын
skip to 1:30 for tutorial
@21catk
5 жыл бұрын
Thank you! This was really helpful and easy to follow
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@birdysviews
3 жыл бұрын
How can I automate this, Whereby every time I add new information, with dates, that it sorts automatically on input ?
@vivianventura2978
5 жыл бұрын
Thanks it worked perfectly, but I have to do it every time I put a new data and date, how can it sort automatically?
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes! You may need to write a macro code for that.
@kristinapadilla4912
4 жыл бұрын
Did you ever figure out how to automatically sort new data you input? This worked great for me but it's frustrating that the settings aren't automatic once configured. I would like to have new data automatically sorted as well
@tillytogs
3 ай бұрын
Sagar how do I make it to auto sort as I'm putting data in please 😊
@jasbirkaur1184
3 жыл бұрын
What if I am having two rows of headers?
@tanishkarichelon3410
3 жыл бұрын
How do I sort it only by date and not year?
@titu-xf8wi
4 ай бұрын
English m smjhaya but jaldi 2
@Llihor
Жыл бұрын
Sirji aap purush nahi, maha purush Hain
@rferia539
4 жыл бұрын
This doesn't work. It still sorts by the month not the year. You guys need to do one that sorts by YEAR. That's the whole point of dates - it doesn't end with month! So unhelpful
@roccod1018
3 жыл бұрын
Thanks for the video. I have my sheet sorted by date but when I add data to the next row it does not sort automatically. How can I fix this?
@madskillz1o1
4 жыл бұрын
INFO FOR INTERNATIONAL PEOPLE: you need to set the correct locale for your sheet, or else date validation WILL NOT WORK, which is expected and logical In my country we write dates like day.month.year , so at first it did not register. But even when I set that, sorting STILL DID NOT WORK. I think I also had to set "format as date" for it to work. Keep trying, looks like it's buggy!
@gieselman
5 жыл бұрын
Validation is key...thank you.
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@arunaagt8229
3 жыл бұрын
How to change date format? Date /month/year
@nicolomarila
2 жыл бұрын
Is it possible to automatically sort the dates
@iwuzwitu1
2 жыл бұрын
Thank you Sagar! Your video was a big help to me. Great job explaining!
@UEGICTCHelpdesk
2 жыл бұрын
thanks
@Sagarclips
2 жыл бұрын
Thanks. Please consider subscribing to the channel.
@jessm.8317
8 ай бұрын
Thank you so much!
@Sagarclips
8 ай бұрын
You're welcome!
@markiejackson6208
Ай бұрын
Thank you!
@Sagarclips
Ай бұрын
You're welcome!
@NoelAbhi1
6 жыл бұрын
Thanks! exactly what I was looking for
@Sagarclips
6 жыл бұрын
Sweet! Would you mind hitting like button and subscribing to my channel for more tech videos? I would be really grateful to you. God bless ya
@ArmanAbroad
3 жыл бұрын
Thank you, very straightforward tutorial
@TheSpainy
5 жыл бұрын
I tried following your tutorial but is sorts the dates all out of order, is there something I am doing wrong? I validated the dates first as you said but it still sorts them incorrectly.
@sereab
5 жыл бұрын
The video poster is incorrect. In his example, he is basically alphabetizing the dates - so he will end up sorting by how "big" a date is. If you notice, it only works because chronological order matches with number "bigness". For example, 11-04-2018 is first because 11 is smallest (compared to 27 and 31). It's ordering by the day lol. If he added 4-09-2019, even though it's the newest date, it will be put first because it has 4 at the beginning. :/
@neilschutte4655
4 жыл бұрын
Appreciate your help! Thank you.
@bernarddebotte5902
5 жыл бұрын
When I put in the data validation it shows errors as it thinks its the American way to do dates. With the months and day the wrong way round. So it shows errors on any date aboth the 12th of the month.
@madskillz1o1
4 жыл бұрын
You have to change the locale of your sheet. But for some reason the sorting doesn't work - even though it should descend by date, it descends as if it were a text value (9 comes before 10, even though 10 is larger...)
@kazimrazatalpur7228
4 жыл бұрын
Thank you so much. This was really helpful and very concise tutorial video.
@GabeEvans-j4l
6 ай бұрын
Thanks boss
@Sagarclips
6 ай бұрын
Welcome
@teejaaydee3686
Жыл бұрын
thank you!
@Sagarclips
Жыл бұрын
😊 Glad I could help! You are welcome! Please consider subscribing to the channel.
@shantimagar5832
3 жыл бұрын
very helpful thanks!
@inelhuayocan_aci
Жыл бұрын
Thank you!
@Sagarclips
Жыл бұрын
Thanks. Please consider subscribing to the channel.
@Lee-ii9mk
5 ай бұрын
Hero!
@Sagarclips
5 ай бұрын
Welcome
@silversteampunk
Жыл бұрын
Thank you so much! I was struggling with this but you made it so quick and straight to the point!
@Sagarclips
Жыл бұрын
Welcome 🙏
@harwindersinghdhillo8865
2 жыл бұрын
Thanks Dear
@Sagarclips
2 жыл бұрын
Thanks. Please consider subscribing to the channel.
@hop5336
2 жыл бұрын
Thank you!
@Sagarclips
2 жыл бұрын
Thanks. Please consider subscribing to the channel.
@jayhager6644
5 жыл бұрын
I was able to easily follow these directions until you got to, "Click on sort range." I don't have that option when clicking the arrow by the column letter. I only have sort sheet A-Z, sort sheet Z-A and Randomize Range. What can I do next to sort by date, instead? Thank you.
@PhotoJeff
5 жыл бұрын
Use the "Data" option in the top menu bar. "Sort Range" is one of the drop-down options.
@greatnorthgmthepas3416
4 жыл бұрын
Yup, Jeff is right. I had the same issue
@sauravrana342
3 жыл бұрын
Thank you brother
@greatnorthgmthepas3416
4 жыл бұрын
Thank you, this worked great!
@nicholascooper8843
3 жыл бұрын
Thank you sir.
@lol_yeahwhatever
4 жыл бұрын
Thanks Sagar! Your videos are very helpful!
@Sagarclips
4 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@ryanmoore6956
4 жыл бұрын
You are a hero.
@mervo82
5 жыл бұрын
Thank you! Your video is easy to understand!
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@emilyjayasena2624
5 жыл бұрын
Thank you.. well explained video
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@aosbo4
4 жыл бұрын
Thank you sagar s! gosh bless!
@Sagarclips
4 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@AmyLynneBaldwin
4 жыл бұрын
Thanks so much!!
@Sagarclips
4 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@kimr1814
5 жыл бұрын
Thank you so much. This helped a lot.
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos?My heart would be grateful to you. May God fulfill all your wishes!
@silia900
4 жыл бұрын
very helpful!!
@Sagarclips
4 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@matthewshambler2644
5 жыл бұрын
Great explanation! Thanks a million!
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@TvsMrDanger
5 жыл бұрын
Thank you! very helpful.
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos?My heart would be grateful to you. May God fulfill all your wishes!
@kimboclothes
4 жыл бұрын
THANK U!!!
@Sagarclips
4 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@lilianbaker1525
5 жыл бұрын
OMG thank you!@!!!
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos? My heart would be grateful to you. May God fulfill all your wishes!
@quietsloop3980
5 жыл бұрын
Thank you!
@Sagarclips
5 жыл бұрын
You are such an amazing person! Would you mind hitting like button and subscribing to my channel for more tech videos?My heart would be grateful to you. May God fulfill all your wishes!
@jelkastoparmetelko9748
5 жыл бұрын
Very helpful, clear and easy to understand Thank you so much!!
@Sagarclips
5 жыл бұрын
Thanks for the compliment. Would you mind hitting like button and subscribing to my channel for more tech videos?My heart would be grateful to you. May God fulfill all your wishes!
Пікірлер: 85