0

Column A has values manually input each week. I want to show that value in a different cell C1. e.g. The value of A1 to be shown in C1 then when A2 has a value it overwrites the previous value in C1 and when A3 has a value it overwrites the previous value in C1 and so on. So the current value in column is automatically shown in cell C1.

Can this be done?

0

Yes it can be done.

E.g.:
=OFFSET(A1,COUNT(A:A)-1,0)

Note: this works only if you fill column A without gaps.

  • For me this produces this error 'You've entered too few arguments for this function'. – Dennis Sep 2 '17 at 11:38
  • I've typed it from phone, couldn't check, please try the corrected version. – Máté Juhász Sep 2 '17 at 12:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.