The cell limit of the RANK function has been increased to 50 million cells. If more than 50 million cells are used with the RANK function, the model rolls back and a notification displays.
The 50 million cell limit does not account for summarized values or the Time and Versions lists. This means you can use the RANK function with a line item with a Cell Count of greater than 50 million cells if there are less than 50 million nonsummarized cells.
As the number of cells you use with the RANK function increases, so does the duration of the calculations.
Thanks for submitting your idea!
... View more