Wayne,

That's a harder question - what if you have a tie for second, or a 3-way tie for first, or.... of
course, we had ignored ties before, so we will do it again ;-)

Use this in, let's say, I8

=LARGE(C:C,2)

and

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

If there is a tie for first, the formula immediately above will not return the second name...

Bernie
MS Excel MVP


"wayne" wrote in message
. com...
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
re.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