simple question..

[vailante]

Hello. This is my first time..

I think it is a simple question. In my old computer, I think when I typed the name of a cell (for example A1), in a another cell (for example B1) , it will return easily the value of the cell (in this case A1) in the new cell (in this case B1).

Now, in my new excel, I can´t do that. I am always asked to insert a function. there is the icon fx (insert function) in the formula bar.. Well, I don´t want any function, I want the value of the cell A1 in the cell B1.

RESUME:
My goal is to have for B1 the value of A1, for B2 the value of A11, for b3 the value of A21, and so on... sincerely I don´t rememeber how I use to do this..

Thank you very much and I hope I´ve been clear.[/b][/b]

 

[Todd Bardoni]

In B1 type:-

=A1

 

[vailante]

that´s it Thanks. But how can I have in B1 the value of A1, in B2 the value of A11, for b3 the value of A21, and so on... sincerely I don´t rememeber how I use to do this.. if it´s possible.

Thank you

 

[just_jon]

that´s it Thanks. But how can I have in B1 the value of A1, in B2 the value of A11, for b3 the value of A21, and so on... sincerely I don´t rememeber how I use to do this.. if it´s possible.

Thank you

Try --

=INDEX(A:A,(ROW()-ROW($A$1))*10+1,0)

 

[vailante]

hummm... nop ... my excel is Portuguese. I tryed using a similar formula but I couldn´t find out how it worked.. thank you anyway.

 

[just_jon]

Maybe --

=INDEX(A:A;(ROW()-ROW($A$1))*10+1;0)