Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 12 Mar 2013 01:25:24 +0100How to select the top "values" in each row of the spreadsheethttps://ask.libreoffice.org/en/question/12643/how-to-select-the-top-values-in-each-row-of-the-spreadsheet/I teach a math class and when I give 8 quizzes, I drop the two or three lowest grades for each student. How can I accomplish this in Libreoffice Spreadsheet?Wed, 20 Feb 2013 16:03:35 +0100https://ask.libreoffice.org/en/question/12643/how-to-select-the-top-values-in-each-row-of-the-spreadsheet/Answer by mahfiaz for <p>I teach a math class and when I give 8 quizzes, I drop the two or three lowest grades for each student. How can I accomplish this in Libreoffice Spreadsheet?</p>
https://ask.libreoffice.org/en/question/12643/how-to-select-the-top-values-in-each-row-of-the-spreadsheet/?answer=12693#post-id-12693It depends how you need your data next. But let's assume you want just a sum of the points minus 2 lowest:
`=SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2)`
or maybe you need the average:
`=(SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2))/(COUNT(A1:A9)-2)`
Or you might find `=QUARTILE(A1:A9;1)` an interesting function :)Thu, 21 Feb 2013 05:44:20 +0100https://ask.libreoffice.org/en/question/12643/how-to-select-the-top-values-in-each-row-of-the-spreadsheet/?answer=12693#post-id-12693Comment by qubit for <p>It depends how you need your data next. But let's assume you want just a sum of the points minus 2 lowest:</p>
<p><code>=SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2)</code></p>
<p>or maybe you need the average:</p>
<p><code>=(SUM(A1:A9)-SMALL(A1:A9;1)-SMALL(A1:A9;2))/(COUNT(A1:A9)-2)</code></p>
<p>Or you might find <code>=QUARTILE(A1:A9;1)</code> an interesting function :)</p>
https://ask.libreoffice.org/en/question/12643/how-to-select-the-top-values-in-each-row-of-the-spreadsheet/?comment=14394#post-id-14394@bobarags -- did this Answer help you out?Tue, 12 Mar 2013 01:25:24 +0100https://ask.libreoffice.org/en/question/12643/how-to-select-the-top-values-in-each-row-of-the-spreadsheet/?comment=14394#post-id-14394