find highest number display the complete row
 

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

find highest number display the complete row
 

Assume the data you show is in A10:A12

=Index(A10:A12,Match(Max(C10:C12),C10:C12,0),1) & " " &
Index(B10:B12,Match(Max(C10:C12),C10:C12,0),1) & " " &
Max(C10:C12)

--
Regards,
Tom Ogilvy

"Paul" wrote in message
om...
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