formula to return data from cell

EVAI

New member
Joined
Apr 6, 2013
Messages
1
Reaction score
0
Points
0
Hi there,

I have data in Cell A1 - A100. If I am sitting in Cell B1. How can I bring back data from Cell A2 & cope the formula down?

Many thanks
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
In cell B1, type this:
=A1

Then double click on the small black box on the bottom right corner of cell B1, and the formula will be copied down.
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
2010
Hello EVAI
If I understand correctly, you are wanting to show values in Col B based on whats in Col A , but offset by one row.

If this is correct, type =A2 in cell B1, then drag this down to cell B99, or double click as Jeffrey has described. You say you have data in A1 as well, but Im assuming that this
might be (e.g.) labelling that you dont want in Col B.

HTH
Hercules
 
Top