a rank) in thehelper column.
Listing sorted values
The helper column can be used to retrieve sorted values by rank.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
Basic text sort formula
To dynamically sort text values in alphabetical order, you can use a formula based on the COUNTIF function. In the example shown, the formula in C5 is: =COUNTIF(countries,"
