Count difference based on Range
 

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

Count difference based on Range
 

In C1 enter:

=ABS(MATCH(B1,A:A,0)-ROW()) and copy down
--
Gary''s Student - gsnu2007


"Richhall" wrote:

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

Count difference based on Range
 

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

Rich