I have a formula that is finding rank even when filtered. Now I need to turn that rank into a percentage, 1-100, even when filter also. The formula for the rank is =SUM(IF(SUBTOTAL(103,OFFSET($R$2:$R$1022,ROW($R$2:$R$1022)-ROW($R$2),0,1))>0,IF(R2>$R$2:$R$1022,1)))+1
Solved by E. J. in 24 mins