+ Reply to Thread
Results 1 to 10 of 10

Increasing by a number diagonaly.

Hybrid View

  1. 10-04-2013, 04:21 AM #1
    system0
    system0 is offline
    Registered User
    Join Date
    10-04-2013
    Location
    korean
    MS-Off Ver
    Excel 2010
    Posts
    10

    Increasing by a number diagonaly.

    ed.JPG

    like this

    i cant range for diagonal and 1 1, 1 2~~~~
    how i can this?
    Help me please
    Last edited by Fotis1991; 10-04-2013 at 04:29 AM. Reason: Pls use correct titles according forum rules!
    Reply With QuoteRegister To Reply
  2. 10-04-2013, 05:31 AM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Increasing by a number diagonaly.

    table doesn't look right ,down the bottom it goes from
    17,18,19,to 119,111,112
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 10-04-2013, 05:38 AM #3
    system0
    system0 is offline
    Registered User
    Join Date
    10-04-2013
    Location
    korean
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Increasing by a number diagonaly.

    Quote Originally Posted by martindwilson View Post
    table doesn't look right ,down the bottom it goes from
    17,18,19,to 119,111,112
    edd.jpg

    like this?
    Reply With QuoteRegister To Reply
  4. 10-04-2013, 06:12 AM #4
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Increasing by a number diagonaly.

    post a workbook not an image!
    Reply With QuoteRegister To Reply
  5. 10-11-2013, 01:56 AM #5
    system0
    system0 is offline
    Registered User
    Join Date
    10-04-2013
    Location
    korean
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Increasing by a number diagonaly.

    Quote Originally Posted by martindwilson View Post
    post a workbook not an image!
    my workbook and wanted like workbook is here https://skydrive.live.com/?cid=a283c...8DB587ACBB!105

    How i can made like this?
    Last edited by system0; 10-11-2013 at 02:09 AM.
    Reply With QuoteRegister To Reply
  6. 10-11-2013, 02:24 AM #6
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Increasing by a number diagonaly.

    Hi system0,

    I can write some code that will move diagonally & paste the values you want.

    How does this work with all of the data you have posted in your Worksheet?

    Can I ask What are you doing this for?

    It would help me understand what you want if you explain what you're trying to achieve.

    Thanks
    Remember you are unique, like everyone else
    Reply With QuoteRegister To Reply
  7. 10-11-2013, 02:31 AM #7
    system0
    system0 is offline
    Registered User
    Join Date
    10-04-2013
    Location
    korean
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Increasing by a number diagonaly.

    Quote Originally Posted by noboffinme View Post
    Hi system0,

    I can write some code that will move diagonally & paste the values you want.

    How does this work with all of the data you have posted in your Worksheet?

    Can I ask What are you doing this for?

    It would help me understand what you want if you explain what you're trying to achieve.

    Thanks

    Hello it is a map point data for game
    i want making game so i want how to this
    can you writing How to do for me?

    sorry for My bad English
    thanks
    Reply With QuoteRegister To Reply
  8. 10-11-2013, 03:33 AM #8
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,940

    Re: Increasing by a number diagonaly.

    =column()&" "&row() try this and copy the formula towards right and down
    Reply With QuoteRegister To Reply
  9. 10-11-2013, 07:58 PM #9
    noboffinme
    noboffinme is offline
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Increasing by a number diagonaly.

    Hi system0,

    I've attached a file that selects the numbers from the first worksheet & pastes them in the order you've shown in your post.

    It takes about 10 minutes to run as it's copying & pasting 65,000 values.

    Let me know if this is what you're after.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 10-13-2013, 06:34 AM #10
    system0
    system0 is offline
    Registered User
    Join Date
    10-04-2013
    Location
    korean
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Increasing by a number diagonaly.

    Quote Originally Posted by noboffinme View Post
    Hi system0,

    I've attached a file that selects the numbers from the first worksheet & pastes them in the order you've shown in your post.

    It takes about 10 minutes to run as it's copying & pasting 65,000 values.

    Let me know if this is what you're after.
    oh its too help for me!
    Thanks for help! TT
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. This made me laugh
    By Kyle123 in forum The Water Cooler
    Replies: 3
    Last Post: 04-11-2013, 04:31 AM
  2. I made an AMV
    By tigeravatar in forum The Water Cooler
    Replies: 4
    Last Post: 12-04-2012, 07:18 PM
  3. overtime total is diferent when made by excel than when made by hand
    By tecnico in forum Excel General
    Replies: 5
    Last Post: 04-16-2012, 08:12 PM
  4. can this be made smaller?
    By fivermsg in forum Excel General
    Replies: 1
    Last Post: 03-28-2007, 01:56 PM
  5. I had the pre-made excel
    By honsbeek in forum Excel General
    Replies: 6
    Last Post: 12-25-2005, 11:17 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1