Excel Tutorial - Sort Data Automatically based on multiple columns without using macros

This tutorial shows you how to sort data automatically easily in excel, based on 2 or more columns of data (without using macros)
Download Excel File at : www.teknisha.c...
Digital Products:
🔷 gumroad.com/te... 🔷
Check the below Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/Te...
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18

[@nagarajkammar8178]

Super More Helpful 🙏🙏Thank You.

[@TEKNISHA]

Glad it was helpful!

[@eb_reviews]

Thank you. Was looking for a solution to sort dates without macro.

[@TEKNISHA]

Glad it was of help

[@arjunrajkumar100]

Nice !

[@jaywindross6693]

Thank you for the tutorial. It was very helpful! However, I'm having an issue when copy and pasting the formula for the 2nd and 3rd rows and renumbering them, they are giving values as "0" instead of the values that are in the raw data.

[@TEKNISHA]

Hi jay, make sure that you are fixing the ranges correctly.

[@jaywindross6693]

@@TEKNISHA thanks for the response. I didn't realise some of the cells had been merged which was causing this effect.

[@TEKNISHA]

Glad that it worked..

[@krisdelacruz1308]

hi how do you fix if the rank tied, it becomes n/a if tied

[@fatimacook390]

Will thi work if you add a new salesperson to the list?

[@TEKNISHA]

If the list is going to be dynamic, then I suggest you need to fist make your sales data as a table and then apply this method.