Incremental cell block (A1+2 = A3.....is it possible ???)

For example, I have a data like this :

	A	B	C
1	Brad	Judith	A1+2=A3
2	Emile	Carmen	A3+2=A5
3	Judith	Agustine	A5+2=A7
4	Philip	Chris	A7+2=A9
5	Carmen
6	Mark
7	Agustine
8	Mike
9	Chris
10	Merry

The result supposed to be like in column B (I wrote the formula like in column C, but it give me #VALUE)
Because the data is so many, It take hours to do manually.... is there a way ?

Any suggestion ?

Many thanks !

Not sure I understand your logic. Are you trying to add names?

Taking your formula in C1 "Brad" + 2 = "Judith". Can you post an example sheet clearly showing your desired solution.

Thanks

Dave H

hi tanangc, welcome to the forum. try:
=INDIRECT("a"&3+(ROW()-1)*2)

Sure, I realised when Benishiryo posted the solution.

Good luck

Dave H

you cannot do a direct sum of "A1+2" because Excel will take the value of A1 plus a value of 2. so i used the INDIRECT formula to have a calculation inside. the calculation is basically:
the alphabet "A" & to join with an amount of 3+(ROW()-1)*2
ROW() will give the row number of that particular row. ROW() in A1 returns 1. ROW() in A2 returns 2. ROW() in B1 & B2 returns the same results, 1 & 2 respectively.
so the final result for A1 is 3+(1-1)*2=3
A2 will be 3+(2-1)*2=5

joined with the alphabet "A" will be A3, A5 respectively. hope that helps