MIN

[JBoyer]

=IF(F11=MIN($F$5:$F$17),"",IF(B11<>"",VLOOKUP(B11,$J$2:$Q$6,7,FALSE),""))

I'm currently using this formula to check which one is the lowest value and
if it is make it "".

It works fine but I'd like to check for the lowest 2, so I want if to make
it "" if it is min OR second lowest, but i dont know a function to find the
second lowest value in a set of numbers.

Thanks in advance for any help!

 

[RagDyeR]

Check out the Small() function.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

=IF(F11=MIN($F$5:$F$17),"",IF(B11<>"",VLOOKUP(B11,$J$2:$Q$6,7,FALSE),""))

I'm currently using this formula to check which one is the lowest value and
if it is make it "".

It works fine but I'd like to check for the lowest 2, so I want if to make
it "" if it is min OR second lowest, but i dont know a function to find the
second lowest value in a set of numbers.

Thanks in advance for any help!

 

[T. Valko]

Try this:

=IF(F11<=SMALL($F$5:$F$17,2),"",IF(B11<>"",VLOOKUP(B11,$J$2:$Q$6,7,FALSE),""))