Is there a Formula that will fill data into every 2nd cell?

[Sineadd]

Hi

I am trying to take data entered from say B3:D3 and use a formula so that it will post into every 2nd cell on a different worksheet.

So it would post to C7, E7, G7 etc

Is this possible

Thanks
Sinead

 

[sadboy309]

Bạn kiểm tra số Cột này:
Công thức:
= IF (MOD (COLUMN (), 2), 1, "")

 

[FormR]

Is this possible

Hi, you could try this in C7 copied across - change the sheet name as appropriate.

=IF(ISODD(COLUMNS($C7:C7)),INDEX('Sheet1'!$B$3:$D$3,ROUNDUP(COLUMNS($C7:C7)/2,0)),"")

 

[Sineadd]

Thank you so much this works perfect

 

[Sineadd]

Hi, you could try this in C7 copied across - change the sheet name as appropriate.

=IF(ISODD(COLUMNS($C7:C7)),INDEX('Sheet1'!$B$3:$D$3,ROUNDUP(COLUMNS($C7:C7)/2,0)),"")

Thank you this worked perfectly