Blank cells

[arif]

Sirs

tell me how to put text only in cells that have same data

and how to copy text in dropdown way in each alternative cell

response is awaited

 

[Somendra Misra]

Hi Arif,

Can you explain your problem with a sample file, what are you looking for?

Regards,

 

[arif]

Hi Arif,

Can you explain your problem with a sample file, what are you looking for?

Regards,

Sir
I v attached sample data

i want same data "100" in each alternative cell by dropdown option (if possible)

how can it be done

 

[Faseeh]

HI,

Put this is D6 and drag down:

=IF(MOD(COUNTA(D$5:D5),2)=1,100,"")

Change 2 in red ( to say 3 or 4) to change repeat.