Today I faced the challenge of having to find the rank of a text string in a range of text strings. Or put another way, in what position would the entry sit alphabetically?
The RANK function only works on numeric values. So instead, we have to resort to logic.
This will figure out how many cells within the range A1:A5 are less than or equal to A1, the value that we're trying to rank.
A beautiful yet simple piece of logic, learned from "anhn" in VB Forums.