Discussion Locked

Excel calculation

0 helpful

2 replies

by shailendra_d Mar 27, 2006 last reply Mar 27, 2006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

how to know the 2nd highest value & 2nd smallest value in a array in excel ?As we know Max will give maximum value & Min will give minimum.

2 replies

use Large and Small for your formulae. ie; =Large(ARRAYNAME,2) for the 2nd largest and =Small(ARRAYNAME,2) for the second smallest.

On mine it's called N.Min(array;2) and N.Max(array;2)

This discussion is closed to new replies.