Excelerate2004
Programmer
Is there a function to find the 2nd highest value amongst a range of values?
I have 4 columns, labeled: A, B, C, D.
If I take the Max value of those 4 columns, then subtract the max from each of the individual columns then the lowest resulting value is the 2nd highest.
Is there an easier way to do this?
Thanks,
I have 4 columns, labeled: A, B, C, D.
If I take the Max value of those 4 columns, then subtract the max from each of the individual columns then the lowest resulting value is the 2nd highest.
Is there an easier way to do this?
Thanks,