Ignore a Value

  • Thread starter Thread starter Laddy
  • Start date Start date
L

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
 
Back
Top