Question on RANKCUMULATE formula
Kindly refer screenshot below. I am experimenting with the RANKCUMULATE formula with two versions shown below, respectively in the columns labelled "Account Counter 1" and "Account Counter 2".
"Account Counter 1" which has the formula RANKCUMULATE(To Change, 1, ASCENDING, TRUE, Country) is working correctly.
"Account Counter 2" has the simpler version of the formula with just RANKCUMULATE(To Change. 1) but it is not working correctly as shown below - the numbers should be running in sequence from 1 to 150 corresponding to the number of rows in the module but is not. Instead we have the first 5 from 1 to 5 in the correct sequence and then it jumps to 41 - does anybody know why this is happening?