Hi all I am new to this programming with Excel but I am trying to find a way
to look through a range of cells to find the highest number.

I want to display the neighboring cells to that highest number on another pl
ace, like on the top of my page. So I got a setup like this, and I am lookin
g for the highest number in column C:

A B C
text1 number1 10
text2 number2 98
text3 number3 85

I want some formula or something so that on the top of the page, so say abov
e text1, I can display the line

text2 number2 98

either in three different cells or (preferably even) in one cell

This is so that I can display the maximum (98) on the top of the page, which
is divided in two split screens.

Hope I explained the problem well enough and I would be happy with any sugge
stion.

Thanks in advance!
Paul