Rank by alphabetical order

This tutorial shows how to rank text by alphabetical order through the use of an Excel formula, with the COUNTIF function

EXCEL FORMULA 1. Rank by alphabetical order

EXCEL

Rank by alphabetical order

=COUNTIF($B$5:$B$11,"<="&B5)
GENERIC FORMULA

=COUNTIF(range,"<="&text)

ARGUMENTS
text: Text to rank.
range: A range that contains the text to rank.

EXPLANATION
This formula uses the COUNTIF function to rank a list of text in alphabetical order.

RELATED TOPICS

Related Topic Description Related Topic and Description
Rank list of value How to rank a list of values
Rank by group How to rank a number by group
Rank ignoring zeros How to rank numbers ignoring zeros (0)

RELATED FUNCTIONS

Related Functions Description Related Functions and Description
COUNTIF Function The Excel COUNTIF function returns the number of cells in a range that meet a specified criteria