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

Connexion
sort
VLOOKUP
Excel to XL
COUNTIF

Essential reading

FizzBuzz in Excel

Do you document your spreadsheets? We use the FizzBuzz word game to illustrate the importance of documenting your spreadsheets.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.