3 highest values

Bridge

New Member

Join Date: Jul 2005

Posts: 2

22nd Jul 2005

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

Attached Thumbnails

« Using INDEX w/MATCH to get data from unsorted source | Find and replace of word causes change of font formatting »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Top 3 highest values	Gilbo	Microsoft Excel Misc	7	31st Dec 2009 10:20 AM
Looking up the highest values.	Shotodru	Microsoft Access	1	9th Sep 2005 03:56 PM
Re: 3 highest values	Bob Phillips	Microsoft Excel New Users	1	23rd Jul 2005 01:13 PM
3 Highest Values	=?Utf-8?B?Q2hyaXNI?=	Microsoft Excel Worksheet Functions	6	19th Oct 2004 02:37 PM
Three Highest Values	=?Utf-8?B?Y2hyaXNo?=	Microsoft Excel Misc	1	19th Oct 2004 01:40 PM