Excel Tutorial to Sort Data Automatically without using Macros

Tutorial to Sort Data Automatically in Excel including Duplicates (without Macros) using Rank and Index/Match Formula

Digital Products:

Recommended Gadgets/Products:

Check the below Playlists..

Excel Tutorials:

Excel Chart Tutorials:

Excel Pivot Table Tutorials:

Excel Gsuite Tutorials:

Excel Tips & Tricks:

Powerpoint Tutorials:

Gadget Reviews:

Thanks for watching!!! 😊🙏

Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.

Follow me on below to stay connected👇

[Luisyclaudia]

Thank you very much! Your video was amazing and extremely helpful. I got it perfectly. Thank you for helping the community with such videos

[danieltiburcio]

This video was extremely clear and helpful. Thank you very much!

[Stop_War_Fight_with_Pollution]

Thank you very much Sir.
I was so sad before watching your video. But its solved my problem in sorting duplicate values.
God bless you.

[mohdsyafiqsharani]

Really appreciate the knowledge given. Super helpful in trying to auto sort the rank during a tournament.

[thakuranujsingh]

Super Video,
Anyone can easily understand this, @Thank u so much.

[lauracath]

Great video Teknisha! Thank you for helping me out! I was getting desperate as the only tutorials I found were too easy (using the SORT button, duh!) and the ones using Macros (not an option for my specific case).

[rayharrison]

Easy to follow and Script worked without any altering, many thanks

[RaceBeacon]

Does anyone know if you can make images also move with the text? This is something that works with the sort normally

[SibsFish]

I have been trailing the internet for days and days to find this information. Everything pointed towards macros, which i have no knowledge in ! Don't let the views bother you. At the very least your time has helped me and those i have done the formulae for. Thank you @TEKNISHA

[Giridhar.M]

Great ! Really Help full. one small request if i required only Top-10, can you please help me with the formula

[simonetommasinipodcast]

Great video and great explanation ability!

[khansvirtualdiary]

Thank you so much sir for your reference reply.

[johnrking]

Brilliant video, what an absolute legend

[dustinworthy]

I created my sheet as you did, but when I change the data on the left, it does not auto sort on the right.

[krisdelacruz]

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

[atenterprises]

what to do when values are same in the column rank is showing same please provide soln.

[SaifAHadi]

Appreciate your efforts .. thank you Sir.

[skumargee]

This is amazing. I was able to solve one of my excel
problems with this video. I express my gratitude for uploading this amazingly helpful video.

[zainulabidinhussainkhan]

Sir if the table is sorted with color so then how to do please help

[naufalb.prasetyo]

Great video, you made my day 😁
Thank you 😊🥰