+ Reply to Thread
Results 1 to 8 of 8

Sorting Problem

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Sorting Problem

    Hi Gurus, I would really appreciate some help here with this problem
    I wish to sort my columns 3 ways
    (1) by column F
    then by Column A and column B

    Column F is Currency sorted bt smallest amount
    then for each Meeting in col A
    then for each race in Col B
    Thanks for any help offered
    Graham
    Attached Files Attached Files

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Sorting Problem

    Hi Graham. Paste this in a standard module:
    Please Login or Register  to view this content.
    Last edited by leelnich; 10-14-2017 at 10:26 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Sorting Problem

    Do you need it a macro?
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Sorting Problem

    First of all Jindon thanks again for your help...Yes need VBA in a macro
    I have attached the result worksheet as sorted
    so you will know what I am after
    The macro did not do what I was after as I did not explain in the first place the requirement (Sorry)
    Graham
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Sorting Problem

    Thanks Lee for you help also I have attached a sample sort file to Jindon ( I did not see your post) but I appreciate your help also
    The Vba did not sort in a manner I was after as the Test_Sortes worksheet will show why
    Thank you
    Graham

  6. #6
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Sorting Problem

    Ok Guys, I want to inform you both that I succeeded in sorting by group
    I searched for sorting by group and i needed to add a column which grouped by A&B
    I then sorted that col and then by F
    So all good and I appreciate your help
    Graham

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Sorting Problem

    Isn't it just
    Please Login or Register  to view this content.
    ?

  8. #8
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Sorting Problem

    I apologize wholehearted Jindon, Of course it works.....I must have looked at another column after sorting
    My Bad
    Regards
    Graham

+ 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. [SOLVED] Sorting Problem
    By SportsFan in forum Excel General
    Replies: 9
    Last Post: 03-18-2017, 01:10 AM
  2. Sorting problem
    By Wendy Collins in forum Excel General
    Replies: 2
    Last Post: 10-12-2011, 10:49 AM
  3. Not Sorting Problem?
    By lawdoggy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  4. Not Sorting Problem?
    By lawdoggy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] Not Sorting Problem?
    By lawdoggy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  6. Not Sorting Problem?
    By lawdoggy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. Sorting problem
    By JC in forum Excel General
    Replies: 3
    Last Post: 01-28-2005, 12: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