Thank you so very much for this. I could not figure out why sorting was not working as it should and low and behold I have spacing columns that were blank, deleted then and PRESTO !! Big thumbs up
this is awesome thank you so much clear speech, concise explanation, assumes that the audience is smart enough to understand and gets to the point, knows what level people are at in general, not condescending but super up to date information and very easy to listen to. I'm watching this to get warmed up for employment. Thank you very very much for the help
Thank you so much. I have learned so much. Question. Trying to help a friend with an excel sheet. Want to sort it by last name, but she has many empty cells in various columns because the info is not in yet. Should I try to place some identifier maybe a comon letter in all of them that I could go back and delete once the sorting is done? There are also columns with IDs containing letters and numbers. If I set them with text format the sorting will be ok, right?
This is a great video, but I am still having issues sorting. I want to sort 3 columns. I have used the custom sort and chose 3 different colums. It will only sort the first one that is listed. What am I doing wrong? I do this all the time with Excel, but this one will just not work. Thank you for any help.
Chris, great video, but has not quite answered what I was looking for. I want to sort some soccer sports data, the time when a goal was scored. My problem is goals scored in extra time at the end of the first half cannot be recorded as 46, 47, or 48 minutes as the seccond hald clock always kicks off at the 46th minute. So I record them as 45+1 etc. This makes it impossible for me to sort all goals by time as I end up with the first half ET goals as an anomally. Do you have any ideas which can help?
thank you , if i have aexcel sheet and i made some changes then i want to arrange it to the random orignail arrage wihtout cancel the chanes ,or if i have old file its rows sorted and i want to make the new file with the same sort or the column with the same sort what can i do ?
I was trying to sort my rows by the values of the resistors in them. The values contained prefixes and decimal points, like 1.5kΩ, 2.2MΩ, 1.5Ω and so on. I still haven't found a way to do it. This was a list generated by an electronic components distributor, containing the list of components I had ordered, but I needed to get more of them and wanted to easily see which values did I skip so far.
I'm using this formula on a project right now =Sortby($B$5:$C$9,Row(B5:B9),-1) because the Exec Team decided they wanted the 72 individual graphs to be ranked from 5 to 1 instead of 1 to 5 🤯
In the past it seems like if there was, for instance, the number 1 in a cell and I drug the fill handle downward the cells below would fill with sequential numbers. I could while still holding the mouse button hit the Shift key (or maybe it was Control) and it would toggle between copying the #1 all the way down or filling 1,2,3,4 etc. Am I remembering wrong? It's frustrating not having that feature.
Hello, Jeff. If you type 1 in A1, and autofill down, it will keep doing the number 1. If you want the 2 in A2, and 3 in A3, you can either hold down CTRL and Autofill or use the tip I show around 2:30 in this video on AutoFill th-cam.com/video/Pf4Mtm91Qsg/w-d-xo.html I hope this helps.
Help! Working on a budget. Sorting by date works perfectly UNTIL I choose it as the 2nd sort field. If I sort first by type of payment (text) and date SECOND, suddenly 9/4/23 comes AFTER 9/30/23. If I sort only by the date column, they sort as they should. Why?
send me the file. Nothing sensitive or confidential. Just make a test file if needed. Any chance when you do date as the 2nd field, you are sorting Newest to Oldest? That would explain what is happening.
@@ChrisMenardTraining Thanks Chris. I am sorting newest to oldest or oldest to newest in the 2nd field and A-Z in the first field. I created a test field, but I don't know how to send it to you.
it doesn't work... if i want to sort the date ( i have a lot of date( mm/dd/yyy) that i have all mixed up from different years) i cannot sort in the way that you are showing. it keeps almost all the date mixed it .
thank you ! Smooth, practical clear, and straight to the point
You are welcome.
Best instructor
Very explainfull in short time. Clear speech. Love to learn from you.
Thank you! I appreciate the positive feedback.
Thank you so very much for this. I could not figure out why sorting was not working as it should and low and behold I have spacing columns that were blank, deleted then and PRESTO !! Big thumbs up
this is awesome thank you so much
clear speech, concise explanation, assumes that the audience is smart enough to understand and gets to the point, knows what level people are at in general, not condescending but super up to date information and very easy to listen to. I'm watching this to get warmed up for employment. Thank you very very much for the help
Excellent instruction video. I was originally only looking for info on Custom Sorting but picked up so much more from this presentation. Thanks.
a wonderful tips. Your explain is easy to follow. Others go to fast and make people get lost and get confused. Thanks Master
I didn’t skip ads. You deserve more followers!
LOL. Thanks, Lira.
simply amazing! easy to follow!, thanks Chris!
My pleasure!
Thank you so much for this! Your Chanel deserves more subs for sure!
Liked, subscribed and rang the bell.
Awesome. I appreciate it.
Thank you Mr. "Tips"
great video thank you. when i hit ctrl/a it doesn't select the entire data below a certain point. how can i grab the rest of the data? thanks
figured it out thanks
Thank you so much. I have learned so much. Question. Trying to help a friend with an excel sheet. Want to sort it by last name, but she has many empty cells in various columns because the info is not in yet. Should I try to place some identifier maybe a comon letter in all of them that I could go back and delete once the sorting is done? There are also columns with IDs containing letters and numbers. If I set them with text format the sorting will be ok, right?
This solved exactly the issue I was having! Thank you!
Glad to help.
Brilliant!!! Super helpful!!
Thank you!
Thank you for this sorting video. It is helpful.
This is a great video, but I am still having issues sorting. I want to sort 3 columns. I have used the custom sort and chose 3 different colums. It will only sort the first one that is listed. What am I doing wrong? I do this all the time with Excel, but this one will just not work. Thank you for any help.
Chris, great video, but has not quite answered what I was looking for. I want to sort some soccer sports data, the time when a goal was scored. My problem is goals scored in extra time at the end of the first half cannot be recorded as 46, 47, or 48 minutes as the seccond hald clock always kicks off at the 46th minute. So I record them as 45+1 etc. This makes it impossible for me to sort all goals by time as I end up with the first half ET goals as an anomally. Do you have any ideas which can help?
Thank you! absolutely amazing
Thanks, Ana-Maria.
thank you , if i have aexcel sheet and i made some changes then i want to arrange it to the random orignail arrage wihtout cancel the chanes ,or if i have old file its rows sorted and i want to make the new file with the same sort or the column with the same sort what can i do ?
Brilliant
Thank you.
Thanks for these tips
You bet!
Just the guy I was looking for....
Thank you!
Mee too!!!
I was trying to sort my rows by the values of the resistors in them.
The values contained prefixes and decimal points, like 1.5kΩ, 2.2MΩ, 1.5Ω and so on.
I still haven't found a way to do it.
This was a list generated by an electronic components distributor, containing the list of components I had ordered, but I needed to get more of them and wanted to easily see which values did I skip so far.
Thank you💯 just Subscribed!
Awesome, thank you!
Thank you!! Awesome
You're welcome!
I'm using this formula on a project right now =Sortby($B$5:$C$9,Row(B5:B9),-1) because the Exec Team decided they wanted the 72 individual graphs to be ranked from 5 to 1 instead of 1 to 5 🤯
Love it. That is a GREAT function! Thanks, Robert.
thank you this is super helpful
In the past it seems like if there was, for instance, the number 1 in a cell and I drug the fill handle downward the cells below would fill with sequential numbers. I could while still holding the mouse button hit the Shift key (or maybe it was Control) and it would toggle between copying the #1 all the way down or filling 1,2,3,4 etc. Am I remembering wrong? It's frustrating not having that feature.
Hello, Jeff. If you type 1 in A1, and autofill down, it will keep doing the number 1. If you want the 2 in A2, and 3 in A3, you can either hold down CTRL and Autofill or use the tip I show around 2:30 in this video on AutoFill th-cam.com/video/Pf4Mtm91Qsg/w-d-xo.html I hope this helps.
@@ChrisMenardTraining Thanks, Chris. Such good information so succinctly.
Is there a way to sort "word" data by how many times it's repeated. i.e Texas Texas Texas Arkansas. Can I sort it by how many times Texas is repeated
I would create a Pivottable and Count State. Sort largest to smallest. That would work.
Help! Working on a budget. Sorting by date works perfectly UNTIL I choose it as the 2nd sort field. If I sort first by type of payment (text) and date SECOND, suddenly 9/4/23 comes AFTER 9/30/23. If I sort only by the date column, they sort as they should. Why?
send me the file. Nothing sensitive or confidential. Just make a test file if needed. Any chance when you do date as the 2nd field, you are sorting Newest to Oldest? That would explain what is happening.
@@ChrisMenardTraining Thanks Chris. I am sorting newest to oldest or oldest to newest in the 2nd field and A-Z in the first field. I created a test field, but I don't know how to send it to you.
thank you!!!
You're welcome!
So if I format the mixed number and text into number from ribbon panel isn't the same as multiply by 1 method?
I wonder if you could provide the data file, if possible. Thank you again.
I just wish we could sort on a protected sheet. There's an option to allow sorting, but it still won't allow it...that needs to be fixed
it doesn't work... if i want to sort the date ( i have a lot of date( mm/dd/yyy) that i have all mixed up from different years) i cannot sort in the way that you are showing. it keeps almost all the date mixed it .
Make sure your face is on every screen you possibly can, lol
I do. :-)
i love u chris