I was talking about the template provided initially... Your template has the rank formulas that work properly. Where did you get your current template. I struggled for months to figure out =(SUMPRODUCT(SUBTOTAL(3,OFFSET(W18:W1751,ROW(W18:W1751)-MIN(ROW(W18:W1751)),,1))*(W18:W1751=4)))/W3*100. You had it all along.
|