Require help in excel [Solved/Closed]

Report
-
 Anakin -
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
=small(a1:a6,2) will give you second smallest number that is 2
Thanks a lot Venkat for the prompt assistance.