I have a column of text values. I want to rank them alphabetically such as:
=COUNTIF($A$2:$A$100,"<="&A2)
The problem is if $A$2:$A$100 contains blank spaces, then the formula will not work as blank spaces are also ranked. Is there a way that I can rank text values while blank spaces are excluded
Bookmarks