Sorting with functions only

This one is similar to where we use some controls here that make it more user-friendly.

We can push the dynamic sort more by adding CHOOSE function to (SMALL, LARGE and ROW)


This way, we let user decide which order to sort, and when we push more, we can have user selects what columns to show, using simple VLOOKUP and MATCH functions …


Original list
Sorted list
Author: ANmar