I have a ranking formula for numerical values in Column J based on Text
categories in Column A:
=SUMPRODUCT(--(A$13:A$2651=A13),--(J13<J$13:J$2651))+1
It doens't work because some of the cells in Column J include error or text
values.
How can I make this formula work so that it ignores these error/text values?
Thanks!
Bookmarks