How to extract sorted rows from a table in Excel . . . Excel tables allow us to filter and sort data, hiding the surplus and putting it in ascending or descending order. However, clearing the filter and sort state means the table reverts back to its original condition, so you may desire a more permanent solution. Formulas give us the flexibility to decide what, where, and how the data is outputted. In this example, we have a customer table and plan on rewarding the top five longest-serving custo