Hello, thanks for the video, it was very helpful. I would like to ask how can we sort our data by label, you mentioned it a little bit by formatting the cell with the header so that excel automatically distinguished it from the data we want to sort, but unfortunately this tip didn't work on my excel. I'm sure this must have something to do with the settings but i can't find it. Do you have any idea on this matter;
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
You have to make it distinct for the program to understand it's a header. Once you do, everything below the header should be alphabetized. Have you tried changing the color of the header?
I am encountering an issue in this. I have a long list of employees and their data. My data data is getting sorted alphabetically in two parts. From different serials .
Hello, I'm making a list with vocabulary words for my students and some of the words are verbs (and therefore starting with "To"). The problem is that Excel then sorts them under words starting with the letter "T". How can I make Excel sort alphabetically whilst at the same time ignoring the word "To"? Thank you.
in excel i have several columns with words and headers. the columns have different number of words. some of the cells are empty. How to sort all the sheet alphabetically with all the columns in one click?
Excellent explanation. Now I learned. Thank you
Great video the floating arrow is great and probably a lot of work to synchronize it with the flow of the contents of the video. Great job
Excellent video
Thank you for streaming Reverend John Downey III's inaugural sermon! What a gift!
Thank you sir it's video very usefully
thank you so much for your help...greetings from saudi arabia
Thanks, God Bless You !!!
This was so so helpful!!! Thank you!
Thank you so much sir ❤️
Thank you so much for the video tutorial. Appreciate it! :)
Very helpful. Thanks for sharing.
Thanks 😊
Thank you so much!!!!!!
Thanks for sharing
I freaking love your videos...old school, very helpful!!!
thanks for the video
it was extremely helpful
Thank You !
Thank you useful 📸
Very helpfull thank you
thank you very much
Thanks
I have to say thank you.
Good presentation. I have subscribed...
Its so good
Hello, thanks for the video, it was very helpful. I would like to ask how can we sort our data by label, you mentioned it a little bit by formatting the cell with the header so that excel automatically distinguished it from the data we want to sort, but unfortunately this tip didn't work on my excel. I'm sure this must have something to do with the settings but i can't find it. Do you have any idea on this matter;
Tnqqq v much ❤️
Thanks man
GOOD VIDEO
I like how to keep it all very simple. Thank you.
Thank you.
Very useful video.
Thank you, now i can finiish my work
Thanks, sir.
Thank you
thank you
How did the sales stay with the correct name when he sorted?
Can we use it in smart phone as well?
Thank you 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
Try formating them as dates and then sort them like that.. just a thought
Thankyou Thankyou
and how do u sort it together with its sales. pls answer
Block together all of them with cursor
Bro made a 3 minute video out of a 15 second tutorial
Great vid! BUT my header is being sorted alphabetically as well. Does anybody know what I did wrong?
Hi Allie Alba I want to talk to you please get in touch if you see this comment😣😣
You have to make it distinct for the program to understand it's a header. Once you do, everything below the header should be alphabetized. Have you tried changing the color of the header?
Can we sequence data if we have name and no,s in the same column please
I am encountering an issue in this. I have a long list of employees and their data. My data data is getting sorted alphabetically in two parts. From different serials .
Go to 2:30 thank me later
Saved my life - so much unnecessary talking
Thank you.
Thank he is just going on and on
Thank you lol
Hello, I'm making a list with vocabulary words for my students and some of the words are verbs (and therefore starting with "To"). The problem is that Excel then sorts them under words starting with the letter "T". How can I make Excel sort alphabetically whilst at the same time ignoring the word "To"? Thank you.
EXCELLENT
Thank u
in excel i have several columns with words and headers.
the columns have different number of words.
some of the cells are empty.
How to sort all the sheet alphabetically with all the columns in one click?
How about using Iphone on Excel, How to sort A-Z..Can anyone Help thank you advance
*To do this, all merged cells need to be the same size.*
What to do?
Why some eaws cannot be sorted Alphabetically. Can you help me with it?
thanks alotte
Thx
the heading kept being included with the sorting. I don't know where I did wrong. Anyone help, please!
ready staaart>\\
AWESOME
APPLE- I want this in separate cell
Example- A1 B1 C1 D1 E1
A P P L E
Thank you for this! Also, "Frank" backwards is "Knarf", and that's hilarious. (I'm truly sorry. Be glad you don't have my name)
Whenever the click sort, and box pops up.
How to distinguish the head because mine move with the data 🥺😭 HELPPPP
my frist row doesnt change, i try everything as u said. NOthing
wow Grace needs to pull herself up by her bootstraps if she thinks 19 sales is acceptable
George you're on thin ice too
Plese i want it learn how to write on a single line...arrsnged not one going to the left and the other the right
so you dont need to select all the data to sort you'll just click the header.
I don't understand. First, he warns us NOT to include the header - then he tells us to start by clicking on the header.
Coulda been a 30 second vid but whatever
Long video waste time
Thank you!
Thank you
Thanks
Thank u
Thanks
Thank u