+ Reply to Thread
Results 1 to 4 of 4

Sorting a list by its code Chronologically skipping first

  1. #1
    Registered User
    Join Date
    03-16-2013
    Location
    bath
    MS-Off Ver
    Excel 2007
    Posts
    23

    Sorting a list by its code Chronologically skipping first

    Hi, I've had some great help with learning excel here and hoped I could again!

    I have attached a file with the problem...

    I need to create a table with the top 14 'ReNo' for each code listed in columns F1-R1. These need to be in chronological order. Also if the code is part of the latest date then that first ReNo. needs to be ignored (since it will not have completed its cycle).

    I have had help getting to the formula I have but I can't get it to sort in these ways, so as it is its not working right.

    Hope someone can help!

    Example3.xlsx

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,416

    Re: Sorting a list by its code Chronologically skipping first

    Pl see attached file.
    Regarding date and omission of First ReNo more clarification required.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-16-2013
    Location
    bath
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Sorting a list by its code Chronologically skipping first

    Hi AMk,

    Thanks for helping me out! The problem is the ReNos are not in order of highest first and are needed chronologically so when they are drawn into the table, the oldest ReNo needs to be at the top based on the ReNo's first appearance, and the youngest one at the bottom, with only one of each ReNo in each column (so no duplicates).

    Hope that clarifies, little tricky to explain!

    I haven't used this before can you quickly explain its function and name in arrays (which I am learning)? F$1:F1

    Thanks again

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,416

    Re: Sorting a list by its code Chronologically skipping first

    the formula gives ReNo in F2 next in F3 so on.If not ok for this code (278545600110210) give the list of ReNo.

+ 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. Code for skipping cells
    By samdaman91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2013, 02:10 PM
  2. Skipping Code (for testing)
    By dugong in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2008, 12:25 PM
  3. Skipping blank cells in a list to create an uninterrupted list
    By bdance in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2007, 06:26 PM
  4. Sorting movie titles? skipping The, A, An etc?
    By Mr B in forum Excel General
    Replies: 4
    Last Post: 07-09-2005, 04:05 PM
  5. Skipping sections of code
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2005, 09:06 AM

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