MIN

J

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!
 
R

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

T. Valko

Try this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top