Wow wow wow. I learned a ton very quickly today. I immediately put this in my T Shirt inventory workbook to rank my shirt designs by topic/folder name, from highest number of designs per topic to lowest, then alphabetical. I have been doing this manually every time I add a design, which is tiresome and tedious. Thanks so much for the great instructions to make this function clear.
an issue i have found is that when i try and sort cells that have data that as been aquired by formulas it gives a spill error, it works fine if the data is just simply typed in but as soon as i try and sort cells that use formulas to get that data it isnt happy, is there a way to work around this?
One of the best tutorial I have never seen: very clear and effective.
Illustration that audience/student shall find it simple and clear to follow. The English articulation is excellent. Thank you!!
Thank you, that is very kind of you to say. 😀
Wow wow wow. I learned a ton very quickly today. I immediately put this in my T Shirt inventory workbook to rank my shirt designs by topic/folder name, from highest number of designs per topic to lowest, then alphabetical. I have been doing this manually every time I add a design, which is tiresome and tedious.
Thanks so much for the great instructions to make this function clear.
Now go check out the FILTER function... it will blow your mind. ua-cam.com/video/23wnQNpFZho/v-deo.html
Excellent presentation with more examples
Brilliant video. The clearest I've seen on SORT. I'll be checking out your other videos on the new Excel functions
Thanks Ross :-)
great video, i appreciate your composite function examples
Right To the Point , Thanks !!!!
Excellent video. You have over 12K views - you should have over 12K likes.
Thanks Edward. The fact that it helped you is enough validation for me 👍
Extreeeemely Helpful!
Thanks 😁
Thanks a lot Mark, for amazingly clarified tutorial.
You’re welcome.
Thank you! Much appreciated! Very useful video!
You're welcome! I'm glad it was useful. 👍
U helped me a lot thx
No problem, glad I could help 😀
an issue i have found is that when i try and sort cells that have data that as been aquired by formulas it gives a spill error, it works fine if the data is just simply typed in but as soon as i try and sort cells that use formulas to get that data it isnt happy, is there a way to work around this?
Watch this video, it will tell you everything you need to know to use SORT correctly:
ua-cam.com/video/TCwec8-tsDk/v-deo.htmlsi=WmeRLJkGNVHkzmTl
Nice examples Mark.
Thank you - I appreciate the feedback 😀
Great.
Thank You.
can you do 10 rows with numbers 1 to 100 to sort?
Sir, I use Office 2019 but the short formula is not seen here. I will benefit if the solution is given.
Sorry, but it’s currently only available in Excel 365.
i had 7000 rows with 5 column only numbers no text data,sorting ascending order, it did not work at all.
That’s odd.
Which version of Excel do you have?
@@ExcelOffTheGrid microsoft365