Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more

2 replies

Answer 1 / 2
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
Answer 2 / 2

Thanks a lot Venkat for the prompt assistance.
Ask a question