Need number increment formula

[motilulla]

Using Excel 2010
Hello,

In cell C1 value “1” and in cell C2 value “9”

In B6 I want “1 & 9” B7 “2 & 10” B8 “3 & 11”

And increment by 1 from initial values in C1:C2. Please suggest formula

MrExcel Question.xlsm
	A	B	C	D
1			1
2			9
3
4
5
6		1 & 9
7		2 & 10
8		3 & 11
9
10
Sheet1

Cell Formulas
Range	Formula
B6	B6	=C1&" & "&C2

Regards,
Moti

 

[Joe4]

Put this formula in cell B6 and copy down:

=($C$1+ROW()-6) & " & " & ($C$2+ROW()-6)

 

[motilulla]

Put this formula in cell B6 and copy down:

=($C$1+ROW()-6) & " & " & ($C$2+ROW()-6)

Joe4, thank you for super-fast solution, you even did not give me time to log out. I am happy.
Thank you for your time and help. Good Luck!

Regards,
Moti

 

[Joe4]

You are welcome!