• 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. C

    Average best 95 % of list

    Hello guys , I have a problem ( still) . For some reason , the =AVERAGEIF(A1:A100,"<"&PERCENTILE(A1:A100,0.95)) ( with the adapted values to my sheet ) does not work . I wonder whether the "<"&PERCENTILE (A2:A100)is the correct syntax , but Excel Help tends to be very litle...
  2. C

    Average best 95 % of list

    Thank you very much ... I did not know this built-ins functions . Thanks again guys Regards Cristina
  3. C

    Average best 95 % of list

    How do I calculate an average of the best 95 % (lowest values in this case) of some columns (column length is variable)? Thanks in advance
Back
Top