Copy Paste Formula of a range

[auhom_me]

Please Consider Bold characters as Row and Column no
[TABLE="width: 498"]
<tbody>[TR]
[TD][/TD]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]X (CELL A1)[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]X[/TD]
[TD]24/04/2017[/TD]
[TD]INDIA[/TD]
[TD]D2[/TD]
[TD]24/04/2017(CELLB1)[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Y[/TD]
[TD]24/04/2018[/TD]
[TD]CHINA[/TD]
[TD]D3[/TD]
[TD]INDIA (CELLC1)[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Z[/TD]
[TD]24/04/2019[/TD]
[TD]JAPAN[/TD]
[TD]D4[/TD]
[TD]Y(CELLA2)[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Q[/TD]
[TD]24/04/2020[/TD]
[TD]USA[/TD]
[TD]D5[/TD]
[TD]24/04/2018(CELLB2)[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD]W[/TD]
[TD]24/04/2021[/TD]
[TD]CANADA[/TD]
[TD]D6[/TD]
[TD]CHINA (CELLC2)[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD]E[/TD]
[TD]24/04/2022[/TD]
[TD]MALDIVES[/TD]
[TD]D7[/TD]
[TD]AND SO ON[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD]R[/TD]
[TD]24/04/2023[/TD]
[TD]MONGOLIA[/TD]
[TD]D8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD]Z[/TD]
[TD]24/04/2024[/TD]
[TD]TIBET[/TD]
[TD]D9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD]X[/TD]
[TD]24/04/2025[/TD]
[TD]BRUNEI[/TD]
[TD]D10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD]C[/TD]
[TD]24/04/2026[/TD]
[TD]KSA[/TD]
[TD]D11[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

But when I paste formula in D4:D6 from D1:D3 it comes to
[TABLE="width: 314"]
<tbody>[TR]
[TD]Q (cell A4 INSTD OF A2)[/TD]
[/TR]
[TR]
[TD]24/04/2020(B4 INSTD OF B2)[/TD]
[/TR]
[TR]
[TD]USA (C4 INSTD OF C2)[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]In a nutshell it should be appeared like the following in D4:D6[/TD]
[/TR]
[TR]
[TD]Y(CELLA2)[/TD]
[/TR]
[TR]
[TD]24/04/2018(CELLB2)[/TD]
[/TR]
[TR]
[TD]CHINA (CELLC2)[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Maybe

Formula in D1 copied down
=IF(COUNTA(A:C)>=ROWS(D$1:D1),INDEX((A:A,B:B,C:C),INT((ROWS(D$1:D1)-1)/3)+1,1,MOD((ROWS(D$1:D1)-1),3)+1),"")

Format D1:Dn as Short Date

Hope this helps

M.

 

[auhom_me]

Worked!!!!!Thank You

 

[Marcelo Branco]

You are welcome. Glad to help.

M.