+ Reply to Thread
Results 1 to 2 of 2

Data sorting based on time and date

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Data sorting based on time and date

    Hi,

    I have a spreadsheet with two columns of data that are sorted by time and date. I want to compare this data to another set of the same kind and same date range, but with different time intervals.

    How can I organize the data side by side with their respective time stamps?

    Cheers

  2. #2
    Registered User
    Join Date
    08-06-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Data sorting based on time and date

    Organize the columns so that the dates then times are the last of each sets of data. Highlight the most upper right cell of the data then drag to the most bottom left. Use the sort button for accending or decending order. Repeat with the other set of data and that should have done it. Let me know if you've any questions.

+ 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