Thanks for watching the “Beginner to PRO Data Analysis Course” video.
If you are having troubles with the course work, here is some help.
You have two options.
Option 1: Instead of using UNIQUE() for country names, just have the values typed in the cell (you can copy paste the formula as value). Then you can sort the table normally.
Option 2: Change all formulas to array version so the table is automatically sorted.
To do this, you need to update the formulas like this.
See this illustration:
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
© All rights reserved.