[SOLVED]True, False conditions and numbers to grab

Hi

I'm am a total noobie when it comes to Excel, tried it few times in the past for very simple numbers.
Now i was asked if i can do "simple" spreadsheet.
I have stuck where i have to take the lowest number with FALSE in "bid" column and return it to Minimum sell field. Plus get the highest number with TRUE and return it to Maximum buy.
Number of rows with True and False is different every time and sometimes even mixed.

I can bet it is very simple but i just cant find the right function.
Thanks for any help.

Here is one solution

That was first thing i've done but it will not work.
I need to divide them in two groups "False" and "True" and then get the lowest and the highest number from each group.
False will not always be from B2 to B63.

Try this
For Min sell

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter, not just Enter

For Max buy

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter

Hope this helps

Sorry but i have no idea if i can reverse them. I am clueless on how to do this. All i know is that i have a spreadsheet i've uploaded and need to get highest number with True next to it and lowest with False.
Those two numbers need to be displayed in different cells.


Edit.

Got Solution

In G6:
=MIN(IF(NOT(B2:B86),A2:A86))

In G9:
=MAX(IF(B2:B86,A2:A86))

Both formula must be committed with Control+Shift+Enter, not just enter.

Thx to Mr.Jon von der Heyden

Sorry to late fixing my post, same solution.

The reason for asking if you could reverse the True/False was to try to make the formulae work for the whole column, rather than a limited range