Many Thanks
Many Thanks to Aladin Akyurek for his solution and to Henrik for correctly asking his question in a more recent thread <Rank() based on category>!!!!!
Aladin's answer was just what I needed. All I had to do was change "<" to ">" to rank from high value to low value by category. He also corrected, as I see it, the formula put forth by Ola (?) by included "+1".
Again, thanks!
|