Excel help please..

  • Thread starter Thread starter J.E. McGimpsey
  • Start date Start date
J

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