Require help in excel

Solved/Closed
Anakin - Jul 7, 2009 at 08:35 AM
 Anakin - Jul 8, 2009 at 03:49 AM
Hello,

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.

Regards,
Anakin

2 replies

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