Sort data using formulas

Sort data using formulas

1 March 2014

This short article shows you how to sort a range of (unique) data using formulas.

The technique uses the COUNTIF function in a helper column to extract the order range in numeric values. It then uses a VLOOKUP function to create the dynamically sorted list.