Find Highest/lowest numbers!

Hi excelers,
I hope you can help me out. I am trying to write a formula that finds the highest/lowest numbers.

to make it clear here's a figure:

\1

manys thanks

If you posted a spreadsheet instead of a picture, someone could insert formulas ...

I can seen to attach a zip file of excel!

Has to be zipped and less than 100K.