Calculating the difference in a column

[Neil G]

Hi

I am using the following to find the last value entered in a column - it's
actually a league position entered manually as a season progresses.
=LOOKUP(9.99999999999999E+307,OFFSET(K16,0,0,COLUMN()-1,1))

So it returns the number of the last value.

What I'd like to do with it is to also show the difference to the cell above
it (IE show if the team went up or down a place)
So for example, if the last value is 9 and the one above it is 11 I would
like to actually show
9 (+2)
or if the reverse were true and actual is 11 and previos 9
11 (-2)
Any ideas please

Thanks
Neil

 

[Frank Kabel]

Hi
try:
=LOOKUP(9.99999999999999E+307,OFFSET(K16,0,0,COLUMN()-1,1)) & " (" &
INDEX(OFFSET(K16,0,0,COLUMN()-1,1),LOOKUP(9.99999999999999E+307,ROW(OFF
SET(K16,0,0,COLUMN()-1,1))+1))-LOOKUP(9.99999999999999E+307,OFFSET(K16,
0,0,COLUMN()-1,1)) & ")"