Rank Function - Ranking Array Size Limit

J

JonTarg

The rank function in Excel is unable to handle large ranking arrays; i.e.
higher than about 2500 entries in the search list.

No mention is made of a maximum number of search entries in the ranking
array in Excel Help for this function.

Is it possible to rank within lists of search entries greater than 2500?
 
J

JonTarg

Figured out the problem! It was a non-numerical entry in the search array
that threw the rank function off. The Rank function now appears to be working
normally.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Rank with Duplicate Entries 6
Ranking without preset Excel function. 0
Ranking without preset Excel function. 10
Ranking (Correct Order) 4
Rank function with the CTRL D does not advance cells the way I nee 1
if function 3
if function 1
Rank Function 3

Top