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

 

[Toadstool]

Hi Noar33,
You don't say what to do with duplicates so does this work?

Noar33.xlsx
	A	B	C	D	E	F	G
1	0	2	2	1	3		8
2	1	1	2	2	2		7
3	2	2	2	2	2		8
4	0	0	0	1	2		3
Sheet1

Cell Formulas
Range	Formula
G1:G4	G1	=SUM(A1:E1)-MIN(A1:E1)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: select the 4 best values out of 5 in a spreadsheet.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Noar33]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: select the 4 best values out of 5 in a spreadsheet.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sorry about that I did not know. Well noted for future
Thanks

 

[Noar33]

Hi Noar33,
You don't say what to do with duplicates so does this work?

Noar33.xlsx
	A	B	C	D	E	F	G
1	0	2	2	1	3		8
2	1	1	2	2	2		7
3	2	2	2	2	2		8
4	0	0	0	1	2		3
Sheet1

Cell Formulas
Range	Formula
G1:G4	G1	=SUM(A1:E1)-MIN(A1:E1)

Hi Toadstool,

You rock thank you so much ! really appropriated
Noa

 

[Toadstool]

Hi Toadstool,

You rock thank you so much ! really appropriated
Noa

You're welcome.