Copy the most recent entry to a new column

[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

 

[Gord Dibben]

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

 

[jabol75]

=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

 

[Frank Kabel]

Hi
if you have no blank columns in between use the following in G1
=OFFSET($A1,0,COUNTA($A1:$F1)-1)

 

[jabol75]

That is what I need. Thanks a lot

 

[jabol75]

One more thing. How can I modify it if there are a few blank columns
Thank you

 

[Frank Kabel]

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

 

[jabol75]

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