Ignore a Value

[Laddy]

Hello,
I wonder if anybody can help?

I wish to ignore a value should it be returned by a formula.

There are 3 persons in a list...... Tom, Dick and Harry.

Tom has 10 points
Dick has 10 points
Harry has 5 points

I wish to produce a list of leaders which in this case has 2 names ie. Tom
and Dick who both have 10 points.
But when using VLOOKUP the function defaults with the first of the two
names: ie Tom.
I wish to ignore the value Tom in the second cell of the list ( 3 cells) so
that the value of Dick is returned.

Any ideas please since it would work with a IGNORE function.

Thanks

Laddy

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/rank.htm
for formulas to deal with 'double rankings'

 

[Laddy]

Cheers Frank......off to have a look

Hi
have a look at
http://www.cpearson.com/excel/rank.htm
for formulas to deal with 'double rankings'