Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the highest 2 out of 3 values in a formula
Hi Guys, I am preparing a spreadsheet to keep track of my marks at uni. In one of my units I have two sets of 3 tests (ie 3 reading comprehension tests and 3 problem solving tests) and only the highest 2 results from each set of tests will contribute towards my final mark. What I am trying to do is devise a formula so the lowest score in each set of tests is not included in the calculation (or only the highest two are included). The data will be entered into the sheet as follows: reading test 1 (Cell E5) problem solving 1 (Cell E6) reading test 2(Cell E7) problem solving 2 (Cell E8) reading test 2 (Cell E9) problem solving 2 (Cell E10) I hope I have explained this well enough for someone to assist me with my endeavours. Thanks in advance Chris -- christopherp ------------------------------------------------------------------------ christopherp's Profile: http://www.excelforum.com/member.php...fo&userid=4162 View this thread: http://www.excelforum.com/showthread...hreadid=518167 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
array formula values | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions |