Hi all,

I need to identify the top ten extremes (+ive and -ive) in a set of figures. This effectively gives me the largest "10" deviations from 0. It may be for example that 8 of the ten are negative.

I need a formula will compile this list (similar to LARGE() ) but which retains the sign. (so can't just use abs() ).

Thanks in advance

PJ