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

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.

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

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

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

Nice !