bpt2

06-09-2006, 10:57 PM

In a column of numbers what formula will select the second smallest?

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 :)

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?

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?

Powered by vBulletin® Version 4.2.5 Copyright © 2019 vBulletin Solutions Inc. All rights reserved.