Copy the most recent entry to a new column

  • Thread starter Thread starter jabol75
  • Start date Start date
J

jabol75

Hello,

I need your help. I need to do the following. I enter a number i
column A. I enter another number in column B. Then I enter anothe
number in column C etc. What function can I use so the number entere
last is copied to a column G (for example)? Thank you
 
In column G enter =C1

Assuming that numbers were entered in A1,B1 & C1

If I have misunderstood please post back or hang on for someone else to parse
your question.

I'm sure there is more to this than you have outlined.

Gord Dibben Excel MVP
 
=C1 will only copy entry from cell C1. I would like to be able to us
one column as a sort of a buffer. For example, when I enter 21 in A1
this will get copied to G1. Then, I enter 100 in B1 which will b
copied to G1
 
Hi
if you have no blank columns in between use the following in G1
=OFFSET($A1,0,COUNTA($A1:$F1)-1)
 
Hi
use the following array formula (entered with CTRL+SHIFT+ENTER)
=INDEX(A1:F1,1,MAX(IF(A1:F1<>"",COLUMN(A1:F1))))

depening on the type of your values (e.g. only numbers) there're other
solutions which do not require an array formula but the above should
work for you
 
Thank you very much. I have one more question:) Assume I have som
numbers in columns B, C, D, E, F, G, and I want to leave some blan
columns so I will be able to enter some numbers in the future. Th
columns B, D, and F contain my "planned" numbers, while the columns C
E, and G carry "actual" numbers. I have also two columns, for example
and O, which contain my year-to-date numbers - "planned" and "actual"
I will try to visualize my problem:
Columns
B | C | D | E | L | M
| N | O
January February ... ...June Yea
to Date
planned actual planned actual planned actual planned actual

Now, in January I would enter some planned and actual numbers. Thes
numbers would get copied to columns N and O - my planned and actua
Year to Date numbers. In February I repeat the same thing but using ne
numbers. Now the new numbers from February would get copied to my Yea
to Date, etc. How can I do this??? I know I can use copy and paste, bu
I really do not want to do it. Is there a function that will do that
Thank you very much
 
Back
Top