Bantuin bikin rumus :D

	A	B	C	D	E	F	G	H	I
1	Name	=A2	=A3	=A4	=A5	=A6	=A7	=A8	=A9
2	Shield	-	=B3	=B4	=B5	=B6	=B7	=B8	=B9
3	Wood-S		-	=C4	=C5	=C6	=C7	=C8	=C9
4	Flower-S		Shield	-	=D5	=D6	=D7	=D8	=D9
5	Oak-S		Flower-S	Wood-S	-	=E6	=E7	=E8	=E9
6	Bird-S		Shield	Shield	Shell-S	-	=F7	=F8	=F9
7	Shell-S						-	=G8	=G9
8	Scale-S					Flower-S		-	=H9
9	Bronze-S								-

Lagi bikin informasi game game boy advanced. Nama gamenya dokapon
Pas lagi bikin daftar kombinasi tameng yg bisa dibuat, buset dah ... ada 50 biji
Kombinasinya da brapa tuh ...
Emang sih hampir 1/2 nya sama.

Trus gw coba bikin rumus dr xcel.
Hasil penelitian gw
A2 - A50 = B1 - AY1
B2 - B50 = C2 - AY2
C3 - C50 = D3 - AY3

Trus gw nyoba
Di cell B1 gw isi dengan rumus =A2
Pas gw copy kesamping kanan hasilnya
=B2, =C2, =D2, =E2
Padahal maunya sih
=A3, =A4, =A5, =A6

Setelah beberapa hari kemudian ....

Iseng ah ...
Yg =A2 gw tambahin 1 karakter jadi '=A2
Pas gw copy kesamping ... tada ...
'=A3, '=A4, '=A5, '=A6
Sudah hampir bener ...
Cuma ... gw jadi repot ngilangin apostrof-nya

Wahahahaha ...

Ada yg tau cara mudah ga ya?

Makasih ...