Find the two lovest values

Posts: n/a

Find the two lovest values

Hi, I am trying to make Excel find the two lovest values in a range off
numbers.
I can use the =MIN() for the lovest, but how about the next lovest ?

/Ole/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Match function with duplicate values in an array	Richard	Excel Worksheet Functions	3	April 22nd 23 07:45 PM
Can you Find and Replace values with in a formula?	rascall	Excel Discussion (Misc queries)	2	June 22nd 05 11:55 PM
How do I find the two lowest values in a range?	dlroelike	Excel Worksheet Functions	3	February 21st 05 12:12 AM
in excel, how do I find which values doesn't have a pair?	jackies_place	Excel Discussion (Misc queries)	2	December 17th 04 05:43 PM
To find different values in Col B corresp. to repeated vaues in c	K.S.Warrier	Excel Worksheet Functions	7	December 10th 04 10:57 AM

All times are GMT +1. The time now is 05:55 PM.

Menu

About Us