Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3 highest values
hello everyone, i've been trying to figure out what formula i can use to find 3 highest values in a row. in my case am trying to compile student marks to get only the best 3 into a cell, i was able to get the highest only 1 but i need all the three values. see the attached image thanks alot Bridge +-------------------------------------------------------------------+ |Filename: excel.jpg | |Download: http://www.pcreview.co.uk/forums/attachment.php?attachmentid=1833| +-------------------------------------------------------------------+ -- BridgePosted from http://www.pcreview.co.uk/ newsgroup access |
#2
|
|||
|
|||
=LARGE(A2:Z2,1)
=LARGE(A2:Z2,2) =LARGE(A2:Z2,3) if you want to sum them, use =SUM(LARGE(A1:Z1,{1,2,3})) -- HTH Bob Phillips "Bridge" <Bridge.1sksda@ wrote in message ... hello everyone, i've been trying to figure out what formula i can use to find 3 highest values in a row. in my case am trying to compile student marks to get only the best 3 into a cell, i was able to get the highest only 1 but i need all the three values. see the attached image thanks alot Bridge +-------------------------------------------------------------------+ |Filename: excel.jpg | |Download: http://www.pcreview.co.uk/forums/attachment.php?attachmentid=1833| +-------------------------------------------------------------------+ -- BridgePosted from http://www.pcreview.co.uk/ newsgroup access |
#3
|
|||
|
|||
thanks alot Bob Phillips it worked perfect :) -- BridgePosted from http://www.pcreview.co.uk/ newsgroup access |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
how to sum highest ranking values meeting criteria within a limit? | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
3 highest values indicated using formatting | Excel Worksheet Functions |