+ Reply to Thread
Results 1 to 2 of 2

order dates by A-Z given sheet is ordered by codes on different column

  1. #1
    Registered User
    Join Date
    07-08-2015
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    25

    order dates by A-Z given sheet is ordered by codes on different column

    Column A has a set of codes sorted A-Z. Between the codes, the rows are in blank, symbolising they are the same as the code above. ie; A1=001; A2 to A5=blank; A6=002 and so on. The number of blank rows varies each time.
    Column B has a set of dates the codes in A were purchased at. I need to order the dates from oldest to newest, but I can't apply the A-Z sort in the entire column, as it wouldn't bear in mind that different dates correspond to different codes in A.
    Is there any way I could work round this? So far I'm making a manual selection in B and sorting it, but I have 99files to do, each with about 10k rows, so it's going to take forever to do so this way.

  2. #2
    Registered User
    Join Date
    07-08-2015
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    25

    Re: order dates by A-Z given sheet is ordered by codes on different column

    clarification:
    A has a set of numbers and blank cells.
    I want to sort the dates in B given a varying range in A from number, to next non-blank cell.

+ 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. Replies: 1
    Last Post: 12-15-2015, 05:04 PM
  2. Replies: 5
    Last Post: 10-20-2014, 05:52 AM
  3. Replies: 3
    Last Post: 10-19-2014, 05:56 AM
  4. [SOLVED] Order of 3 numbers in a non ordered range
    By dualaudio454252 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2014, 10:39 PM
  5. [SOLVED] Plot two series ordered by different dates in the same graph, on the same x-axis.
    By droppe in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-14-2013, 07:14 AM
  6. Replies: 5
    Last Post: 04-01-2013, 08:19 AM
  7. Replies: 3
    Last Post: 10-21-2005, 01:05 AM

Tags for this Thread

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