+ Reply to Thread
Results 1 to 2 of 2

Date sorting in two columns

  1. #1
    Registered User
    Join Date
    05-11-2021
    Location
    Cambridge, England
    MS-Off Ver
    Windows 7
    Posts
    1

    Question Date sorting in two columns

    Hello,

    I'm struggling to find a solution in excel and hoping you can help, i'm new to the forum so please let me know if 've posted in the wrong area.

    I sort vehicle/Trailer service/ Mots for a few of our teams meaning i have about 90 separate items. I get a monthly list containing Vehicle info with two columns of dates of when each vehicle/Trailer service and Mot is due.

    what i would like to be able to do is sort it so that the spread sheet will put the soonest dates out of the two columns at the top, so i can see which vehicles/trailers need to be booked in, so far I have have only managed to do one column at a time using the sort feature and it would make my life alot easier if I could do both.

    Unfortunately I cant put pictures up of the actual sheet as it obviously has sensitive data such as registrations and addresses.

    Any help would be appreciated, Thankyou

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Date sorting in two columns

    Can you work up some dummy data so we can see how your data is set up? Just need enough representative data to understand what you have and then show what you want your results to be. I am not getting a clear picture from your description.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. Sorting Blocks of cells multi row and columns of data with a date priority
    By jpthelpguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2018, 01:39 PM
  2. Replies: 0
    Last Post: 05-15-2013, 09:18 AM
  3. Sorting facebook statistics by time (from date columns)
    By kala1928 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2013, 01:26 PM
  4. data sorting by date then user and the SUM of columns
    By robjearls in forum Excel General
    Replies: 0
    Last Post: 03-15-2012, 01:00 PM
  5. Newbie needs help in sorting out a couple of date columns
    By slicksilver79 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-04-2012, 11:14 PM
  6. Combining columns together and sorting by date
    By impala096 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2011, 08:49 AM
  7. 3 columns; date and two data, problem is sorting and calculating with respect to date
    By phosphorescence in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2008, 04:21 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