• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    highlight top 80% values (sum) without sorting

    Try this: Cells I2 - I11 enter randome values Col. K: not sorted 80%: Cells K2=I2, K3=IF(SUMA($K$2:K2)/SUMA($I$2:$I$11)<0.8;I3;""), K4=IF(SUMA($K$2:K3)/SUMA($I$2:$I$11)<0.8;I4;"") etc. Col. L: sorted 80%: Cels: L2=LARGE($I$2:$I$11;ROWS($I$2:$I2))...
Back
Top