Sir Ji, I need ur guidance in solving this.. In a sheet, A1, B1, C1 are the three cells. C column will be given by me as input (positive no). B1 = A1 - C1 and so on for B Column A2 = B1 and so on for A column Now, A1 is to be automatically derived, such that "0" comes in A column. Thanks in Advance 😊🙏
Hi I’m new to your channel and am finding it extremely helpful as I’m working to brush up on my excel skills. I was wondering if you might be willing to do a video on extracting data from reports or other docs/applications. I also believe that data could be then turned into charts/pie charts? Thank you for sharing your knowledge!
If you only select one cell in the column and select sort a to z. it simply sorts that column and all the other columns stay in the same place. So data gets mixed up.
Hello, An old simple problem I have in Excel. I have the following Column in Excel: R101, R10, R11, R1, R20, R2 And after sorting, I expect to Get: R1, R10, R101, R11, R2, R20 But I do not. Instead, I get: R1, R10, R101, R11, R2, R20 How can I do it? Thanks. Moshe.
You mentioned to add a blank row or column to separate the data into another section that doesn't get sorted along with the rest. Well, I have done that accidentally, and now my data won't sort along with the rest -- but I can't find the blank row. How do I group the data together again?
Sorting by date doesn't work on Excel. It ALMOST gets it right. It used to get it right back in the old days. Now, I have to correct it every time. Have others run into this problem?
If I have a 20x10 chart with 200 unrelated to each other numbers and want to sort them from smallest to largest, how do I do that? It would be easy if they were written in one row or one column, but there are 10 rows and 20 columns.
I know this has been a minute but I'm just not seeing it. What am I doing wrong if when I click on the name column and A to Z and it puts one of the names above the labels. Like the column labels I have set up.
What if my sorting is about letters and not numbers? I am using excel 365 and it allows me to sort but only by colors, numbers and that I cant get it to sort alphabethically
Hi How to i keep my sort order ? eg i have a table of names and points and copy to another area to sort. I highlight, and choose sort function, and sort per points. Now, the following week i will update this table, and copy to the area mentioned, i go to sort and my sort order has gone. I want to keep that sort order, Any ideas?
galat hai 55000 khud le rahi ho aur mehnat krne wale ko kewal 5000 kamse kam kuch to sahi karo jisko dekho dhoka dhoka, kam se kam khud 60 per lo aur usey 40 per to do because uski hi to mehnat hai aapka kya hai free me
![CHILE vs. BRASIL [1-2] | RESUMEN | ELIMINATORIAS SUDAMERICANAS | FECHA 9](http://i.ytimg.com/vi/5ObJt_71AYc/mqdefault.jpg)
Sometimes I find that something as basic as this can really set you apart from other people in the work place! Great video
Excellent video and it was exactly what it says it is; all about sorting! Clear, concise and right on point! Thanks so much!
dude you are lifesaver.
Very nice presentatio. I have learnt a new thing.Thanks
Just that simple step of inserting blank row or column to protect other data CHANGE EVERYTHING - THANKS 🙂
Thanks a lot, this helped me very much, so many years I never used excel until now, my mistake and now I am learning.
Really I can't thank you enough.
Do you have any videos of how to make charts please
Really simple explanation, thank you
Great video. Basics raise curiosity.
Amazing info direct to the point👍
Always appreciate your tutorials
Very clear and helpful. Thank you.
You are a Legend.
The CTRL + A = solved my issues. Damn those small issues/mistakes sometimes complicate things.
TY Bro!
Really, a great video, I understood the things very easily after seeing your video.
you are amazinggggg...thank you ....support from India
This is very informative. We'll done. Thank you!
Your tutorials are sick..😁😁😁
Man, that's the perfect tutorial I've been needed. Great thanks from me to you!
Extremely helpful! Thanks
Sorting was exactly the key I needed to transform my ability to use Excel.
Appreciate the directness
EXCELLENT VIDEO THANK YOU 👍
This is so simply awesome! Thank you!!!!
Thank you heaps, super clean and helpful video.
Excellent job 😊
Sir Ji, I need ur guidance in solving this.. In a sheet,
A1, B1, C1 are the three cells. C column will be given by me as input (positive no).
B1 = A1 - C1 and so on for B Column
A2 = B1 and so on for A column
Now, A1 is to be automatically derived, such that "0" comes in A column.
Thanks in Advance 😊🙏
Thank you.
Thanks!
Thank you so much this was more than helpful!
Glad it helped! Thanks so much for your kind gift.
Thank you so much
Love this!!
thank you. it helped.
As splendid as in your other briefs. Thank You. 🙏
Hi I’m new to your channel and am finding it extremely helpful as I’m working to brush up on my excel skills. I was wondering if you might be willing to do a video on extracting data from reports or other docs/applications. I also believe that data could be then turned into charts/pie charts? Thank you for sharing your knowledge!
thank you, this worked
Thank youuuuuu😊
Always enjoy your videos.
❤❤❤ Thanks for sharing thanks thanks thanks
Thanks very much !!!!
Thank you :)
TOO GOOD, Thank you
If you only select one cell in the column and select sort a to z. it simply sorts that column and all the other columns stay in the same place. So data gets mixed up.
Very helpful, thank you! :-)
always great Many thanks
Thank you!!
Awesome! easy to understand. Thanks, alto.
Thanks
Fantastic
I want to abuse you bro. You are the best solution provider one of the best creators on RUclips
Thanks!
Welcome! Thank YOU for your support! Sorry for my delay in saying thanks.
@@techteachersandstudents Wish I had more to support your work! Maybe someday:) TY
Well, I guess we see what it takes for this guy to reply to his followers.
V helpful
awesome
Hello, An old simple problem I have in Excel.
I have the following Column in Excel: R101, R10, R11, R1, R20, R2
And after sorting, I expect to Get: R1, R10, R101, R11, R2, R20
But I do not. Instead, I get: R1, R10, R101, R11, R2, R20
How can I do it? Thanks. Moshe.
You mentioned to add a blank row or column to separate the data into another section that doesn't get sorted along with the rest. Well, I have done that accidentally, and now my data won't sort along with the rest -- but I can't find the blank row. How do I group the data together again?
When I try it it says I can’t change part of an array. What does that mean?
sir plz attach the file for practise in description it's helps a lot
bit.ly/sortexcel
Sorting by date doesn't work on Excel. It ALMOST gets it right. It used to get it right back in the old days. Now, I have to correct it every time. Have others run into this problem?
If I have a 20x10 chart with 200 unrelated to each other numbers and want to sort them from smallest to largest, how do I do that? It would be easy if they were written in one row or one column, but there are 10 rows and 20 columns.
do we need a specific setup to make sure we dont accidentally sort the column names as well?
i kept screwing that up.
👍
I know this has been a minute but I'm just not seeing it. What am I doing wrong if when I click on the name column and A to Z and it puts one of the names above the labels. Like the column labels I have set up.
Hmm. Mine doesn't work. I have a dozen rows - but it only sorts 2-12 and leaves the top row as is. ??
What if my sorting is about letters and not numbers? I am using excel 365 and it allows me to sort but only by colors, numbers and that I cant get it to sort alphabethically
Did i notice the names of the players not be in alphabetical order when the team was in the harder part of the sort?
Hi How to i keep my sort order ? eg i have a table of names and points and copy to another area to sort. I highlight, and choose sort function, and sort per points. Now, the following week i will update this table, and copy to the area mentioned, i go to sort and my sort order has gone. I want to keep that sort order, Any ideas?
Sir, I worked on file and sorted the data and Saved, Now, How to undo the sorted filter, or how to go back to original position ,
Hello, How to automatically count sorted items?
how to sort alphanumeric data ?
Love Seth Curry
I try to sort and it says "You can't change part of an array."
MINE SORTS SEPARATELY EVERYTIME
mujhe ye sakht napasand hai ki mehnat krne waley peechhe hai unhe aise hi thaga jata hai aabhi sarkaar unhe thag rahi hai
this is NOT everything about Excel sorting... you have not talking about row sorting.. or option sorting..
galat hai 55000 khud le rahi ho aur mehnat krne wale ko kewal 5000 kamse kam kuch to sahi karo jisko dekho dhoka dhoka, kam se kam khud 60 per lo aur usey 40 per to do because uski hi to mehnat hai aapka kya hai free me
nothing changes this, and this videos blantant lie that its one click is frustrating
Unclear video
And when Excel is STUPID, and DOES sort your title row with the rest, what then? I'm not sure saying that Excel is smart quite covers it.