PDA

View Full Version : excel formula



bpt2
06-09-2006, 10:57 PM
In a column of numbers what formula will select the second smallest?

Renmoo
06-09-2006, 11:08 PM
Hi. Can you please rephrase your query? Thanks!

Cheers :)

bpt2
06-09-2006, 11:35 PM
I have a column of 4 numbers.
In the third column I am selecting the smallest absolute number using the formula: =IF(AND(ABS(G1)<=ABS(G2),ABS(G1)<=ABS(G3),ABS(G1)<=ABS(G4)),K1,H1)
Now in the third column I want to select the second lowest absolute number.
The results are linked to a letter which in turn defines a particular profile.
Column:
G H I J K
-8 I I I E
4 P P C C
0 A B A B
7 S S S F
Column H is defined: =IF(G1>=0,"E","I"), =IF(G2>=0,"P","C") etc
Column K is defined: =IF(H1="E","I","E"), =IF(H2="P","C","P") etc.

Is that clear enough?