View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default find minimum of range based on multiple criteria

Mine has one les IF <vbg

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Weissme" wrote in
message ...

Hi, Thanks! I will try that, but I also found that this works:

{=MIN(IF($K$6:$K$49=1,IF($H$6:$H$49=O10,$F$6:$F$49 )))}

Most exciting triumph of my day I think.

Thanks again!


--
Weissme
------------------------------------------------------------------------
Weissme's Profile:

http://www.excelforum.com/member.php...o&userid=34044
View this thread: http://www.excelforum.com/showthread...hreadid=544071