• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Blank cells

A

arif

Member
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 said:
Hi Arif,

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

Regards,
Click to expand...
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
 

Attachments

  • Alternative cell.xlsx
    8.1 KB · Views: 5
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.
 
You must log in or register to reply here.
Back
Top