+ Reply to Thread
Results 1 to 2 of 2

Switch from attached excel sheet to two matrices = one pair and one odd.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Switch from attached excel sheet to two matrices = one pair and one odd.

    Switch from attached excel sheet to two matrices = one pair and one odd
    We have in the example a planilia that uses from 01 to 50, I need to change
    * Only pairs =
    02 04 06 08 10 12
    14 16 18 20 22 24
    26 28 30 32 34 36
    38 40 42 44 46 48
    50 52 54 56 58 60
    62 64 66 68 70 72
    74 76 78 80 82 84
    86 88 90 92 94 96
    98 00
    And another odd
    01 03 05 07 09 11
    13 15 17 19 21 23
    25 27 29 31 33 35
    37 39 41 43 45 47
    49 51 53 55 57 59
    61 63 65 67 69 71
    73 75 77 79 81 83
    85 87 89 91 93 95
    97 99

    So you have to create two excel sheets, just swap the tem in the example
    https://www.excelforum.com/attachmen...1&d=1511373989
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Switch from attached excel sheet to two matrices = one pair and one odd.

    then, is to change to 50 pairs and another flat of the 50 odd
    are two matrices.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert Single Pair of Columns to 3 Column (Pair) List
    By kencoburn in forum Excel General
    Replies: 7
    Last Post: 03-04-2017, 01:43 PM
  2. Replies: 10
    Last Post: 12-24-2016, 04:43 PM
  3. Date Problem-See attached Excel Sheet
    By Goldenone in forum Excel General
    Replies: 3
    Last Post: 11-15-2014, 09:41 PM
  4. Replies: 0
    Last Post: 11-28-2013, 06:06 AM
  5. Convert multiple column to excel sheet attached
    By ahad_bwp in forum Excel General
    Replies: 2
    Last Post: 07-11-2012, 09:04 AM
  6. Replies: 15
    Last Post: 12-03-2009, 05:15 AM
  7. Can I switch back to Excel sheet while a form is shown?
    By Ai_Jun_Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2005, 08:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1