Require help in excel

Anakin - Jul 7, 2009 at 08:35 AM
 Anakin - Jul 8, 2009 at 03:49 AM

Pls help me by suggesting any formula or function for selecting two minimum values from range of numbers in excel spreadsheet.

For example:
If there are numbers: 1, 2, 3, 4, 5, 6, and so on. Now i apply a formula MIN for selecting a minimum value out of this range. It will return '1' as result. But now suppose i need to check the next minimum after '1', what will be the function or formula applied to retrieve the desired value?

Pls assist.


2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 7, 2009 at 10:04 PM
=small(a1:a6,2) will give you second smallest number that is 2
Thanks a lot Venkat for the prompt assistance.