From:  Don Wiss <donwiss@no_spam.com>
Date:  09 May 2020 06:47:53 Hong Kong Time
Newsgroup:  news.alt119.net/comp.lang.apl
Subject:  

Re: Getting "Grade Up" results in Excel VBA?

NNTP-Posting-Host:  161.22.36.62

On Fri, 8 May 2020 07:34:59 -0700 (PDT), TC  wrote:

>at any rate, without a laptop, I can't be sure that Excel's
>=rank(number, namedarrayrange) function does exactly what you want, but if not it is a close base to build from. 

Thanks for the suggestion. I looked up Rank. It would work, but as it
returns a single number, I'd have to run in a loop for each number in the
vector. This, of course, leaves me with the question of which is more
efficient.

Don. www.donwiss.com (e-mail link at home page bottom).