We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

How to select the top "values" in each row of the spreadsheet [closed]

asked 2013-02-20 16:03:35 +0200

bobarags gravatar image

updated 2021-05-23 11:56:13 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-23 11:56:20.381075

1 Answer

Sort by » oldest newest most voted
2

answered 2013-02-21 05:44:20 +0200

mahfiaz gravatar image

It 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 :)

edit flag offensive delete link more

Comments

@bobarags -- did this Answer help you out?

qubit gravatar imagequbit ( 2013-03-12 01:25:24 +0200 )edit

Question Tools

Stats

Asked: 2013-02-20 16:03:35 +0200

Seen: 1,414 times

Last updated: Feb 21 '13