How to use SORT and SORTBY Functions in Excel

[@Luciano_mp]

Thank you for all the great videos. They are very helpful! Deb has a very good teaching talent in my opinion!

[@SimonSezIT]

Glad you like them! :-)

[@maxmillman9477]

Great quality video, thank you

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 😃

[@user-Abadir]

❤❤❤❤❤sort by

[@staninjapan07]

Thank you. Either this is not applicable to desktop Excel from around 2018 or I have not understood. Though this and similar videos show how to do this with a few columns, I have only two to which I am trying to apply this, though there are more active columns in the sheet. Alas... Thank you anyway. In case anyone seeing this knows what to do and has five minutes to tell me, this is my situation... I am asking my English students to give me advice on the most important items for an emergency bag. Column A - item names Column B - the total number of votes the item gets from a class of six groups of students Columns C to H - the number of votes from members of each of six groups Column B is a SUM of Columns C to H. Column J - attempting to use this sort function on columns A and B in order to show realtime results as I enter the students' votes in each group's columns. Goal - to have a top 5 summary of items (with or without numbers of votes) Many thanks.