Hi ... first time here !!
Probably a simple problem. I've got a range of cells let's say F39:M39.
I want to select the lowest value 0. What I'd call a MINIF. No mention
in Excel. Some scouting around on the Web refers to CSE formulas. But I
can't seem to get it to work.
I'm trying .... =min(if(F39:M390) and the Control / Shift / Enter ??
Do I have to activate CSE in Excel first or am I just doing it wrong ?
Thanks
JH
--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile:
http://www.excelforum.com/member.php...o&userid=25171
View this thread:
http://www.excelforum.com/showthread...hreadid=386666