| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 72270 | 2006-09-06 10:57:00 | excel formula | bpt2 (6653) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 482976 | 2006-09-06 10:57:00 | In a column of numbers what formula will select the second smallest? | bpt2 (6653) | ||
| 482977 | 2006-09-06 11:08:00 | Hi. Can you please rephrase your query? Thanks! Cheers :) |
Renmoo (66) | ||
| 482978 | 2006-09-06 11:35:00 | 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? |
bpt2 (6653) | ||
| 1 | |||||