+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 19 of 19

Need help in dating columns

  1. #16
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    8,069

    Re: Need help in dating columns

    Using you attachment in post #5, here's a macro to convert your data into a format better suited for analysis.

    If your spreadsheet should be slightly different, we can make the necessary adjustments.
    Attached Files Attached Files
    HTH
    Regards, Jeff

  2. #17
    Registered User
    Join Date
    02-26-2018
    Location
    Norman, OK
    MS-Off Ver
    2003
    Posts
    9

    Re: Need help in dating columns

    Hi MarvinP:



    I really appreciate your offer to convert my data. I didnít expect that. But Iíll take you up on your offer. Iím attaching the spreadsheet. Thank you for your help.
    Attached Files Attached Files

  3. #18
    Registered User
    Join Date
    02-26-2018
    Location
    Norman, OK
    MS-Off Ver
    2003
    Posts
    9

    Re: Need help in dating columns

    Hi:

    Thanks for your kind offer. I tried posting a response in 2 different ways including sending you my data but I don't see either one in this thread. I hope you received my response. Please let me knoow. Thanks

  4. #19
    Forum Expert
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,420

    Re: Need help in dating columns

    The data on the seven pages has been copy and pasted onto page 1 and is then converted into columns, using formulas similar to those presented earlier, on sheet1.
    Conditional formatting was added to to column B so that zero values, which otherwise would have shown as 12:00 AM, are hidden.
    A pivot table has been added for demonstration purposes, however the values look reasonable to me.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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