Which formula to use

#1
Hi,

I have 2 columns of numbers (x,y), I want to find which value in column X will give the maximum value in column Y. What formula does it? preferable ones that can be used in Excell or OO Calc.

Thanks!