copy cells

G

groaner

I want to enter values in A1 and B1 and have them appear in D1 and E1
respectively. I can do that by just putting the formula "A1 and "B1" in
D1 and E1.

But, When I enter a different value in A2 and B2, I want the new values
to replace the previous ones in D1 and E1 - and so on with A3/B3, A4/B4
etc.

Can I do this with a simple formula? I'm not an experienced user.

Thanks
 
T

Trevor Shuttleworth

D1: =OFFSET(A1,COUNTA(A:A)-1,0)
E1: =OFFSET(B1,COUNTA(B:B)-1,0)

Assuming there is no other data in columns A and B and that there are no
gaps in the data

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display only unique values in CONCATENATE formula 4
Forcing User inputs 1
Round up & Autosum 1
LOOPING STRUCTURE DESIRED 4 TWO RANGES 2
How to copy the function SUM but offseted in 7 columns 2
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE 4
copy formula 3
Very strange behaviour of VLOOKUP in Excel 2010 4

Top