i-nth logo
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.

Full article: Sort data using formulas