# modify formula to find second smallest number

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

MIN(IF(\$EH\$14:\$EH\$105462=EH15,\$DH\$14:\$DH\$105462)))

Many thanks

Ian
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Older 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.

=IF(A1=B1,SMALL(A1:A6,2),99)
1
Commented:
Agree with Martin that the small function can do it, but there is a condition on another column, so try this
=SMALL(IF(\$EH\$14:\$EH\$105462=EH15,\$DH\$14:\$DH\$105462,10^10),2)
It is an array formula, inserted with Ctrl+Shift+Enter
1

Experts Exchange Solution brought to you by