Custom Auto Fill

**thelordabdo** · 04-22-2013, 03:59 AM

Hello,
I have an equation at a cell lets say (=A1+B1+C1) , i want the second equation to be (=A2+B1+C4) , the third to be (=A3+B1+C7) and so on , i know there is no problem with (A) and i could solve the (B) order by typing it like (=A1+B$1+C1) , the question is there a fast solution to solve the (C) problem ? , or I must correct it manually ?

I have Excel 2013
thanks for advance.

**AndyLitch** · 04-22-2013, 04:07 AM

=a1 + $b$1 + indirect((address((row(c1)*3)+1,3,1,1)))

**benishiryo** · 04-22-2013, 04:10 AM

hi thelordabdo, welcome to the forum. try:
=A1+B$1+INDIRECT("C"&1+(ROW(1:1)-1)*3)

or:
=A1+B$1+INDEX(C:C,1+(ROW(1:1)-1)*3)

**thelordabdo** · 04-22-2013, 04:24 AM

I really Appreciated your very fast reply , but it didn't work with me at the following example , As at this Examble D1,D2,D3 must be all the same and equal to (3) , but this didn't happen .

**thelordabdo** · 04-22-2013, 04:25 AM

thanks for your reply , I will try it now

**JosephP** · 04-22-2013, 04:27 AM

perhaps
=A1+$B$1+INDEX(C:C,(ROW()-1)*3+1)

**thelordabdo** · 04-22-2013, 04:29 AM

Originally Posted by benishiryo

hi thelordabdo, welcome to the forum. try:
=A1+B$1+INDIRECT("C"&1+(ROW(1:1)-1)*3)

or:
=A1+B$1+INDEX(C:C,1+(ROW(1:1)-1)*3)

Thanks very much , the first solution works perfectly

, the second didn't .

**thelordabdo** · 04-22-2013, 04:40 AM

Originally Posted by JosephP

perhaps
=A1+$B$1+INDEX(C:C,(ROW()-1)*3+1)

thanks for your addition solution , but there is an error at the formula , but never mind

, as benishiryo first solution already solved the problem .

**JosephP** · 04-22-2013, 05:13 AM

there is no error although if your settings require semicolons rather than commas you should make that adjustment as you would have to for the other suggestions. I would avoid indirect whenever possible although if you don't have too many formulas it should not be a problem