Excel help please..

[J.E. McGimpsey]

One way:

=OFFSET(A1,COUNT(A2:A1000),0)

Note: You'll get a circular reference error if you don't have at
least an entry in A2.

 

[Keith Blake]

I have a sheet that I am keeping golf score on, what I have is in columns
A3,A4,A5,A6,A7 etc I will input my scores.
I want Excel to display the latest score in A1

So basically When in input a score in A3 I want it to displayed in A1, then
the next week when I input my score in A4 I want it to replace what is in A1
with the new score in A4 (I will be totalling the score elsewhere)

Thanks
Keith

 

[Keith Blake]

Thanks,
it worked fine.....

Keith