Sort Excel Table by Drop-Down Cell Value | Easy in Excel 365

[@enricodecrescenzo1306]

Great example Alan! I like the nice touch with IF formula to decide the ascending/descending order depending on the data you selected, well thought!

[@Computergaga]

Thank you, Enrico.

[@spilledgraphics]

Exactly Enrico ! Alan, made a nice touch there, making the formula more "equipped" for the solution 😁👌

[@spilledgraphics]

Dynamic Arrays = The Future of Excel 🔥🤯😵🔥 !! awesome tips Alan 👌👌

[@Computergaga]

Thanks, Carlos.

[@wayneedmondson1065]

Hi Alan. An awesome lesson and challenge! Just for the fun of it, I came up with the following single formula solution for the table: =IFS(SEQUENCE(ROWS(tblPizza[#All]))

[@nsanch0181]

Thank you for the useful sort video. It was creative how you changed the sort order from ascending to descending based on the column; that will be useful.

[@Computergaga]

Thank you 😊 Great to hear.

[@zmurfarna]

Exactly what I was looking for. Thank you!

[@Computergaga]

Excellent! You're very welcome.

[@IvanCortinas_ES]

Excellent tutorial Alan, as always!! Thank you!

[@Computergaga]

Thank you, Iván.

[@invenioadvisors]

Awesome as usual Alan!

[@Computergaga]

Thank you 😊

[@MohammadShahidulIslam-dm9qd]

Awesome and brilliant interactions in sorting data

[@Computergaga]

Thank you, Shahidul.

[@papnyanamah2748]

This is just amazing. Thanks for sharing 👍

[@Computergaga]

My pleasure 😊

[@FRANKWHITE1996]

Thanks for sharing.

[@Computergaga]

My pleasure 👍

[@nadermounir8228]

Awesome Video 📹

[@Computergaga]

Thanks, Nader 😁

[@afzalzamiransari]

Great idea sir

[@Computergaga]

Thank you, Afzal.

[@gangadharbhardwaj]

VERY NICE

[@Computergaga]

Thanks

[@markpodesta4605]

Magic!

[@Computergaga]

Thanks, Mark.

[@stevemansfield8530]

IT's nice though of course another way is just to make the original array an official Excel table with the usual Excel-table functionality allowing you to sort by any column, and ascending or descending as preferred, along with the other normal table functionality such as the ability to create totals and subtotals, create a pivot table from the data and so on.

[@OK-ur2wy]

Hi, many thanks indeed, amazing video and great learning.
Could I seek your advice please on an assets list that has got columns: category, item, user name, etc.
For example, same colleagues received different items e.g. a laptop, a mobile phone etc. How can I create an "Asset clearance List" at the end of an employee's contract where I can list the items s/he received and need to return by the name of an employee. Not sure how, it's confusing, shall I use XLookup, index and match, Vlookup. I'd very much appreciate your advice. Thanks very much again for your amazing videos I'm really learning a lot from you and sharing them with my colleagues.

[@Computergaga]

Thank you, Ali. This sounds like a job for the FILTER function.

[@OK-ur2wy]

@@Computergaga good stuff will give it a try, much obliged

[@gopalashetty3592]

what is beta distribution show it in excel sir

[@JoseAntonioMorato]

I don't understand why you did the column calculation in another spreadsheet when you could have included it in the "Report" spreadsheet's own sorting formula:
=SORT(tblPizza,XMATCH(C2,tblPizza[#Headers]),IF(C2="Pizza",1,-1)) or
=SORT(tblPizza,XMATCH(C2,C4:G4),IF(C2="Pizza",1,-1)) 🤗

[@Computergaga]

No reason. Either way. Nice work, José Antônio.