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 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
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?
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 .
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 , 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.
ok the problem i have is that if I reference a cell that is part of a table, or create a link to a cell within a table in my current sheet, and then sort the rows in my table, the " link to a cell in this worksheet" breaks. or it starts taking me to data in the linked cell, but now the data has changed due to the sorting!!! WHAT DO WE DO ABOUT THAT? please help
Is it even possible to have a table where sorting is being used, and reference cells from that table without the data changing every time a new sort is applied??!!! (THANKS SO MUCH)
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 ruclips.net/video/Pf4Mtm91Qsg/видео.html I hope this helps.
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 🤯
Best instructor
Very explainfull in short time. Clear speech. Love to learn from you.
Thank you! I appreciate the positive feedback.
thank you ! Smooth, practical clear, and straight to the point
You are welcome.
Mixed text and numbers - was very useful to me. Thanks for great tips!
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 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
Excellent instruction video. I was originally only looking for info on Custom Sorting but picked up so much more from this presentation. Thanks.
Thank you for this sorting video. It is helpful.
Excellent video
simply amazing! easy to follow!, thanks Chris!
My pleasure!
Thank you Mr. "Tips"
Brilliant!!! Super helpful!!
Thank you!
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.
Thanks for these tips
You bet!
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! absolutely amazing
Thanks, Ana-Maria.
Thank you💯 just Subscribed!
Awesome, thank you!
Thank you!! Awesome
You're welcome!
Brilliant
Thank you.
This solved exactly the issue I was having! Thank you!
Glad to help.
thank you this is super helpful
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?
thank you!!!
You're welcome!
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
Just the guy I was looking for....
Thank you!
Mee too!!!
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?
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 .
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 , 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.
ok the problem i have is that if I reference a cell that is part of a table, or create a link to a cell within a table in my current sheet, and then sort the rows in my table, the " link to a cell in this worksheet" breaks. or it starts taking me to data in the linked cell, but now the data has changed due to the sorting!!!
WHAT DO WE DO ABOUT THAT? please help
Is it even possible to have a table where sorting is being used, and reference cells from that table without the data changing every time a new sort is applied??!!! (THANKS SO MUCH)
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 ruclips.net/video/Pf4Mtm91Qsg/видео.html I hope this helps.
@@ChrisMenardTraining Thanks, Chris. Such good information so succinctly.
So if I format the mixed number and text into number from ribbon panel isn't the same as multiply by 1 method?
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.
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.
I wonder if you could provide the data file, if possible. Thank you again.
i love u chris
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
Make sure your face is on every screen you possibly can, lol
I do. :-)