I get the same results when testing with RANK so hopefully just changing the formula to read as follows in B1 and down will work for you:
EDIT: In addition I changed % in the formula in B1 and down so that it reads:Let me know if you have any questions.![]()
=RANK(E1,E$1:E$10,1)<90.00000000001%*COUNT(E$1:E$10)
Bookmarks