True, False conditions and numbers to grab

[S3n]

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 divide numbers to two groups (False,True) and get the lowest from "False" group and the highest from "True" group.
Number of rows with True and False will not always be the same, sometimes even mixed.

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

link to spreadsheet: http://hotfile.com/dl/106330737/290e9b3/STUCK_-_Copy.xlsx.html

 

[Jon von der Heyden]

Welcome to the board!

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.

 

[S3n]

omg
You Are My Hero !

Thank You very much for such a quick reply