Hi all,

I'm a VBA beginner and I'm trying to create a function in VBA for extrapolating the first, second, third or whatever ordinal number smaller than the max
(for instance =TakeMinMax(“A1:A100”,3) would take the third number smaller than the max in the range A1:A100).

Any ideas on how to do this?

Thanks in advance.