Search : in
By :

Selecting the 5 highest values

Last answer on Jul 29, 2009 4:03:43 am BST imz, on Jul 28, 2009 10:23:40 am BST 
 Report this message to moderators

Hello,
Can someone pls help me on excel

I am trying to select top 5 values from a range of numbers. What macro should i use so that excel figures out the 5 maximum numbers from the range of values. i know its easy to extract the highest value by using MAX(Range) formula but that only gives one value. how can we get 5 highest values

Thanks

Configuration: Windows XP Internet Explorer 6.0

Best answers for « selecting the 5 highest values » in :
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
MySQL - SELECT ... YESTERDAY ShowMySQL - SELECT ... YESTERDAY Make use of the following syntax: SELECT * FROM myTable WHERE field_date = DATE_SUB(CONCAT(CURDATE(), ' 00:00:00'), INTERVAL 1 DAY) In order to select previous records: SELECT * FROM myTable WHERE field_date =...
[Myth] Is Kerio 2.1.5 an efficient firewall? ShowIs Kerio 2.1.5 an efficient firewall? Myth Truth Myth Kerio 2.1.5 is used by many as a decent firewall and is thought to be very useful to protect the computer from any harms coming from the Internet. Truth Kerio 2.1.5 has been a very...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Multichannel audio (5.1, 6.1, 7.1) ShowMultichannel audio The term "multichannel audio" refers to the use of multiple audio tracks to reconstruct sound on a multi-speaker sound system. Two digits separated by a decimal point (2.1, 5.1, 6.1, 7.1, etc.) are used to classify the various...
Ask your question Reply

1

venkat1926, on Jul 29, 2009 1:54:01 am BST
  • +1

Use large function
=large(range,1) gives maximum
=large(range,2) gives next lower than maximum
like that use this function. see help

   
Reply to venkat1926

2

 imz, on Jul 29, 2009 4:03:43 am BST

Thanks

   
Reply to imz
Ask your question Reply
They need your help