The general Rank function only can rank correctly while the values are numerous, if there are some text needed to rank by alphabetical order, it will get the errors. Do you have any ways to quickly rank data alphabetically in Excel?
Here I introduce a formula which does you a favor.
Select a cell where you will place the result, type this formula =COUNTIF($B$2:$B$10,"<="&B2) and drag fill handle down to the cells which need to fill with this formula.
In the formula, B2:B10 is the range you want to rank by alphabetical, B2 is the first cell you want to rank.
Tip.If you want to sort names by the last name, please try to use the Kutools for Excel’s Advanced Sort as shown in the following screenshot. It’s full function without limitation in 30 days, please download and have a free trial now.