Min (IF AND) formula accounting for text string?

[Thermalunit]

I joined the board as I am completely stumped by an equation and have been unable to find a solution on any board or through an hour or so of head scratching. I wondered if someone more familiar with Excel may be kind enough to help?

I'm trying to find the minimum value from a table of data if two separate conditions are met. One of the conditions needs to search for a string of text.

I have tried using: =MIN(($K$3:$K$2152=A3)*($ER$3:$ER$2152="*Enable*")*($EG$3:$EG$2152)) as an array but I just get a 0 in return. I can see from the spreadsheet that 0 is not the correct answer.

Any help would be much appreciated.

 

[barry houdini]

Perhaps your numbers in column EG are text formatted, what do you get with

=MIN(IF(($K$3:$K$12=A3)*ISNUMBER(SEARCH("Enable",$ER$3:$ER$12)),$EG$3:$EG$12+0))

confirmed with CTRL+SHIFT+ENTER

 

[Aladin Akyurek]

I think you need to confirm such a formula with control+shift+enter, not just with enter. This also holds for what follows:

=MIN(IF($K$3:$K$2152=A3,IF(ISNUMBER(SEARCH("Enable",$ER$3:$ER$2152)),$EG$3:$EG$2152)))

 

[Thermalunit]

Andrew - apologies - your second solution did work after all! I made an error when placing the sheet name into the equation.

Thanks for your help much appreciated!