+ Reply to Thread
Results 1 to 3 of 3

Custom Sorting issue - will not adhere to pattern

Hybrid View

  1. #1
    Registered User
    Join Date
    09-29-2019
    Location
    Israek
    MS-Off Ver
    2019
    Posts
    2

    Custom Sorting issue - will not adhere to pattern

    Hello,
    I have a csv file attached here.
    Attached is a screenshot of the custom sorting I am applying to the columns A-C.

    The issue is that I am expecting column C to contain patterns of 0-10-20-30-40-50-0-10-20... and repeating.
    In practice this isn't what is happening.

    To be clear, I want the file to be first sorted by column A from 1 to 30, and only then by columns B and C, where each number in column B (for example 5) has 6 values (0-50):

    1,5,0
    1,5,10
    1,5,20
    1,5,30
    1,5,40
    1,5,50
    1,6,0
    1,6,10
    ...
    1,6,50
    ...
    ...
    1,12,40
    1,12,50
    1,13,0
    ...
    ...

    Any clues as to my mistake?
    Thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,080

    Re: Custom Sorting issue - will not adhere to pattern

    But you have duplicate values.

    1,5,0
    1,5,0
    1,5,0

    These will all be sorted together before any

    1,5,10
    1,5,20

    Equally you have multiple 1,5,10s and others too.

    QUESTION: Given the fact you have

    1,5,0
    1,5,0

    where do you expect the second 1,5,0 to appear in the sorted list?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    09-29-2019
    Location
    Israek
    MS-Off Ver
    2019
    Posts
    2

    Re: Custom Sorting issue - will not adhere to pattern

    You're right.. I'll have to check that because the file is too big and maybe I didn't notice that some lines are duplicated.
    Thanks for shining a light on that...
    I'll get back to you when I understand the data a bit better.

+ 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. Search and assign by criteria and create new content with custom pattern
    By pomper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2017, 09:08 AM
  2. Pattern Copying Issue
    By Sharkawy in forum Excel General
    Replies: 18
    Last Post: 10-24-2016, 04:13 AM
  3. creating a custom pattern/sequence based on input freq./duration and priority
    By akamenov88 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-30-2015, 05:00 PM
  4. custom data series pattern fills?
    By pjiman1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2008, 07:33 AM
  5. Sorting Pattern
    By seanyeap in forum Excel General
    Replies: 5
    Last Post: 07-20-2007, 11:41 AM
  6. Excel Sorting by Pattern?
    By Suzi in forum Excel General
    Replies: 2
    Last Post: 06-03-2005, 04:05 PM
  7. [SOLVED] custom cell pattern colors
    By Shooter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-10-2005, 04:06 PM

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