I have the same issue with this formula when I delete an entry.
It just keeps the remaining higher numbers of ranking because of the deletes. It assumes the celss I delete are part of the ranks.
The formula works fine except when I delete. Here is that formula ... What do I do to it to correct the ranking of it?
This is what happens when I have no data in the cells because I have no entries.
I may have only 8 entries or maybe just 6 or even 10.
But this is what happens on the formatting. It wants to include all rows no matter what.
Here is my example for 15 entries.
Now when I delete the last 7 because of no data, it will delete l the #1's or the last 7.
The remaining top 8 will be ranked but not using the lowest numbers for ranking value.
I think the 14,6 needs to be input in the statement somehow of the ABS.
By the way ... wanted to let you know that I am using that formula from post 11 in a column.
Now what I want to do is rank that column with the numerical (1,2,3) ranking system I stated above.
I was able to rank them but the deleted rows affect the column of numerical ranks as you can see above.