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

[@nagarajk7848]

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

[@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.

[@arjunrajkumar100]

Nice !