iHighest iLowest

[BigAl]

I know what iHighest/iLowest do but have found that these are quite often hit by spikes in the price. Is there an easy way to ignore the highest and/or lowest and get the second or even third highest or lowest.

[Keith Watford]

Put the values in an array, sort the array, then you can pick whichever you want from their placing in the array

[BigAl]

GumRai:
Put the values in an array, sort the array, then you can pick whichever you want from their placing in the array

So simple!!

Thanks