Passing 2 Columns to 1 Row

[Guest]

Hi, i'm having dificulties to make a formula that does what i want, and the formula must do like this:
A B C
1 Ivone 111 Ivone
2 Joana 112 111
3 Manel 113 Joana
4 112
....
I'm doing like this but isn't getting good
=IF(D3="text";IF(C2>1;A1;B1);B4) -> is not doing the sequence of A1 - B2 - A2 - B2 get it?
Maybe i'm complicating a little don't i?

 

[Leo Heuser]

Hi

One way:

In C1:

=IF(MOD(ROW()-ROW($C$1),2),OFFSET($B$1,(ROW()-ROW($C$1))/2,0),
OFFSET($A$1,(ROW()-ROW($C$1))/2,0))

Copy down.

 

[Guest]

In http://www.cpearson.com/excel/cells.htm (=range(A:B)(7)), i't seems that does what i want, but the command range doesn't exist in my excell!
Has any command substitute this one or it must be done by other way?
Thanks

"Micos3" escreveu:

 

[Guest]

Thank u it really worked


"Leo Heuser" escreveu:

Hi

One way:

In C1:

=IF(MOD(ROW()-ROW($C$1),2),OFFSET($B$1,(ROW()-ROW($C$1))/2,0),
OFFSET($A$1,(ROW()-ROW($C$1))/2,0))

Copy down.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

 

[Leo Heuser]

You're welcome and thanks for the feedback

LeoH