For example, if you have the following data
The above method won't work, and will ignore MAR02 and FEB05. Try adding a helper column which concatenates the data with something harmless first, before applying the sort.
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?
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
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.