Hello Excel Formula Guru's:

This formula return the lowest of numbers in a row.

Now; need for it to select the 2nd lowest, rather than lowest. If there is not a 2nd lowest, leave as is.



{=IF($E6="","",MIN(IF(ISNUMBER($V$6:$TE$284),IF(($V$2:$TE$2=TG$3)*($E$6:$E$284=$E6)*($V$6:$TE$284)<>0,($V$2:$TE$2=TG$3)*($E$6:$E$284=$E6)*($V$6:$TE$284)))))}

If I were to use the SMALL function instead of MIN, where would I place a "2" in this formula, or a "plus 1"?

(TG$3 is a column heading. . .)

Thanks for any ideas for this. Might be a simple change. . .?

Pete

(Cannot use vba)