D

#### Darren

In column E1 - E4

=LARGE(B1:B4,1)

=LARGE(B1:B4,2)

=LARGE(B1:B4,3)

=LARGE(B1:B4,4)

Next I have the names next to each value:

In column D1- D4

=INDEX(A1:A4,MATCH(LARGE(B1:B4,1),B1:B4,FALSE),1)

=INDEX(A1:A4,MATCH(LARGE(B1:B4,2),B1:B4,FALSE),1)

=INDEX(A1:A4,MATCH(LARGE(B1:B4,3),B1:B4,FALSE),1)

=INDEX(A1:A4,MATCH(LARGE(B1:B4,4),B1:B4,FALSE),1)

So if my chart was:

A B

Alpha 10

Bravo 2

Charlie 6

Delta 8

The result would be:

D E

Alpha 10

Delta 8

Charlie 6

Bravo 2

Here's my problem. Lets go back to the original chart with new values.

A B

Alpha 10

Bravo 2

Charlie 8

Delta 8

The result would now be:

D E

Alpha 10

Charlie 8

Charlie 8

Bravo 2

Which omits Deltas score.

Is there a way I can tell the index command to, if theres a duplicate value,

ignore the previous result?

Obviously this is a much simpler version than the one I have at present which

contains in excess of 70 names and results.