Using Excel functions to dynamically sort data

I am going to show you how to use Excel functions to create a new table from your current table and have it dynamically sorted.

We have a list of people, scores and age. We want to create another table and have it dynamically sort descending the data so it changes as your main table data changes. Change anything in the original table and you will see your new table dynamically sort!