Ask Your Question

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

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

bobarags 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 question is not relevant or outdated by Alex Kemp
close date 2015-10-22 19:42:52.428600

1 Answer

Sort by » oldest newest most voted

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:


or maybe you need the average:


Or you might find =QUARTILE(A1:A9;1) an interesting function :)

edit flag offensive delete link more


@bobarags -- did this Answer help you out?

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

Question Tools


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

Seen: 1,397 times

Last updated: Feb 21 '13