=MIN(IF(A1:A5="Y",B1:B5))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tetsuya Oguma" wrote in message
...
Hi all,

Here is a breeze question for you guys!

I want to get a minimum number in Column B from the numbers whose flag in
Column A shows "Y".

<Scenario 1
A B
1 1
2 Y 5
3 Y 8
4 Y 12

The required function should show 5.

<Scenario 2
A B
1 1
2 Y 5
3 8
4 Y 12

The required function should show 5.

What is the array function to do the above?

Thanks in advance.

Tetsuya Oguma