Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Data in each alternative cell

  1. #1

    Data in each alternative cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Suppose i want to copy each cell data in an alternative cell by formula how can i do it

    i have attached sample file where i have done it manually

    now want to use formula for doing it autimatically

    plz suggest
    Attached Files Attached Files

  2. #2
    Just leave every other cell blank by not entering anything there! Seems there is more to the question than you are giving.

  3. #3
    i can do it manually but same thing i have to type by "pressing enter, then copy and past, then again enter"
    but if there is a formula for drop-down plz inform

  4. #4
    use formula
    =IF(MOD(ROW(),2)=0,100,"")

  5. #5
    Thanks a lot
    seems my problem is solved now

  6. #6
    No, you select every target cell use the Ctl key, then type 100 and hit Ctl-Enter.

  7. #7
    Quote Originally Posted by Bob Phillips View Post
    No, you select every target cell use the Ctl key, then type 100 and hit Ctl-Enter.
    Sir

    can u show in this sample workbook plz sir

    plz
    Attached Files Attached Files

  8. #8
    Not really, that would just show the results, not how to do it.

  9. #9

    Data in alternative cell

    Quote Originally Posted by Bob Phillips View Post
    Not really, that would just show the results, not how to do it.
    Sir
    Ur formulla is useful
    but i want same data in alternative cell plz thats y

    give such a formula if i drop down the list data will be put skipping one cell in between

    thanks

  10. #10
    It wasn't a formula, it was selecting all cells using Ctl-Click and then type 100 and hit Ctl-Enter.

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •