+ Reply to Thread
Results 1 to 6 of 6

Column Display Manipulation

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,392

    Column Display Manipulation

    Attach is the sheet for referance
    I would like to arrange the sheet so that it would show from Column D:

    Jan-06 Jan 07 Jan 08 Feb 06 Feb 07 Feb 08 ....and so on...

    Please help....

    Riz Momin
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    In D2 and copy across,

    =DATE(2006 + MOD(COLUMN() - 4, 3), INT(COLUMN() - 4) / 3 + 1, 1)

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,392
    I appreciate your quick response but i need all column data to move accoringly...

    Please let me know if you questions..

    Riz Momin

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    In D1 and across =10000 * MONTH(D2) + YEAR(D2) and sort left to right by row 1.

  5. #5
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,392
    Thanks a lot...its working

    I would like to like to ask one more question...please help

    I have function :

    =SUMPRODUCT(--(Data!$A$2:$A$1376='Monthly Summary'!$A5),(--(Data!$B$2:$B$1376='Monthly Summary'!$F$2)),(Data!$D$2:$D$1376))

    where the function is Summing the values ..

    In expression ,(--(Data!$B$2:$B$1376='Monthly Summary'!$F$2)),

    i only need to match first 2 character from Data!$B$2:$B$1376 with 'Monthly Summary'!$F$2....

    How would i use this expression to do that...

    Thank u in advance and let me know if you any question...


    Riz Momin

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Maybe

    =SUMPRODUCT( (Data!$A$2:$A$1376 = 'Monthly Summary'!$A5) * (LEFT(Data!$B$2:$B$1376, 2) = 'Monthly Summary'!$F$2) * Data!$D$2:$D$1376)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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