modify formula to find second smallest number

I would like someone to modify the below formula to arrive at the second smallest number.


Many thanks

Who is Participating?
Ejgil HedegaardCommented:
Agree with Martin that the small function can do it, but there is a condition on another column, so try this
It is an array formula, inserted with Ctrl+Shift+Enter
Martin LissOlder than dirtCommented:
Try using the small function where 2 is the second smallest. This looks at the data in A1 and B1and if they are equal it returns the second smallest from A1:A6, otherwise it returns 99.

raceproretiredAuthor Commented:
Thanks to Martin and Ejgil for your contribution.
Your solution Ejgil is perfect
Many thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.