Count difference based on Range

[Richhall]

Hi

If I have a results column of positions that something has finished,
and then I have a column of a persons guesses of where the finishing
positions would be. How do I calculate the difference between the
persons guess for each guess and the actual result please?

i.e

COLUMN A B C

Result Guess Place Difference

Germany England 4
Wales Ireland 1
Ireland Scotland 1
Scotland Wales 2
England Germany 4
France France 0

Cheers

Rich

 

[Guest]

In C1 enter:

=ABS(MATCH(B1,A:A,0)-ROW()) and copy down

 

[Richhall]

Cheers, was getting in a mess with LOOKUP which kept bringing back odd
values.

Rich