Activate formula in columns

[Mamdouh Elfors]

hi.
How do I make activation of the formula in one column, then the second column is empty, then activate it in the third column ... and so on ...

 

[Peter Bartholomew]

It is possible to have a formula which outputs different information on alternate columns but you cannot leave it blank for manual data input or comments.

 

[bosco_yip]

Try,

Change your E2 array (CSE) formula to :

=IF(MOD(COLUMN(A1),2),IFERROR(INDEX($B$2:$B$10,SMALL(IF($D2=$A$2:$A$10,ROW($A$2:$A$10)-ROW($A$1)),INT((COLUMN(A1)-1)/2)+1)),""),"")

 

[Mamdouh Elfors]

thank you bosco
that's awesome..I have solved a problem