select the 4 best values out of 5 in a spreadsheet.

[Noar33]

Hi guys,

I have a simple task to do.
I have a series of 5 digits from 0 to 5 and, I am looking for a formula to select the four best grades and do the sum.
For example, if I have 0, 2,2, 1, 3, I would like to keep 2,2,1,3 and add them .

thanks in advance

[JEC.]

Here you go:

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...readsheet.html