VBA - Find 2nd minimum in list with duplicates

[JeanRene]

Hello,

I'd like to have the vba formula to find the row of the 2nd smallest number in a liste where number, e.g. if I have a list with 9;10;9;10;11; the formula would give me the row number of the first 10 it encounters.

I found an array formula using "large" and "if" to find the 2nd smallest if but it doesn't seem to work if there is only 2 values in the list (if I have 9;10;9;10 it shows 10 as result) and I don't know how to write it in vba...

Any help is welcome!

 

[Peter_SSs]

Thank you again for your help, it has been very helpful

No problem. Glad you have something that you are happy with.