Sorry but I actually need the top 2 entries and corresponding names.

Sorry again
Wayne


On Fri, 27 Jun 2008 09:26:19 +0100, wayne
wrote:

Many thanks for that

Wayne


On Thu, 26 Jun 2008 14:29:53 -0400, "Bernie Deitrick" <deitbe @
consumer dot org wrote:

Wayne,

In cell I7, use

=MAX(C:C)

In cell H7, use

=INDEX(B:B,MATCH(I7,C:C,FALSE))

Of course, you can replase the C:C and B:B with the addresses of the five cells in those columns.


HTH,
Bernie
MS Excel MVP


"wayne" wrote in message
e.com...
Hi,
I have two columns of data, 5 students and their grades in
columns, say B (name) and C (Grade). How can I reproduce the highest
grade and corresponding name in ssay, H7 (name) and I7 (Grade)?
TIA
Wayne