+ Reply to Thread
Results 1 to 3 of 3

Making Columns One...Continued

  1. #1
    Registered User
    Join Date
    04-01-2008
    Posts
    7

    Making Columns One...Continued

    Hi,

    I am trying to find the difference between the last cell of data for a given month and the last cell of the current month's data. I would like to be able to format the data such that there is one column of data with a value for each month over x number of years in sequential order. However, I am having trouble with the way my data is formatted.

    I currently have my data formatted so that it has columns of daily values where each of the columns are months of the year, but these columns are stacked upon each other so that Oct of 2000 is continuous with Oct of 2001, 2002... etc.

    Is there a way I can do this? Please see the attached to get a sense of the format.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    848
    I can give you a solution as a starting point:

    Pivot table!

    (attached)
    Attached Files Attached Files
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    04-01-2008
    Posts
    7
    Thanks again. I'll see what I can do with that. In the meantime does anyone else have any thoughts on finding the difference between the value of the last day of a month and the value of the prior month's last day?

    Thanks!

+ 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