+ Reply to Thread
Results 1 to 6 of 6

columns not sorting correctly

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    Qatar
    MS-Off Ver
    365
    Posts
    3

    columns not sorting correctly

    Ok so this might be a bit confusing to explain. i have this sheets ( attached ) its part of a sales pipeline, now everthing seems to be fine until i try to sort the sheet by the date column

    there are 2 columns that depend on data is a 2nd sheet. the problem is as follows:

    Stage Value Quotation# Probability Creation date Team to Won Last interacted on
    won 8000$ 805 100% 10-07-2019 Socorro 100% 14-11-2019


    the probability column value is based on the stage columns value which is in turn is based on the second sheet the progress to won is based on the cell location under probability column

    the Problem: when i click to sort the sheet by creation date all columns get sorted but the probability colums wont sort in sync with the other cells which leads the progress to won column to screw up as well.


    can anyone help with this?

    PS if my explination is not clear. download and open the sheet, try to change the option from the drop down list in the stage column you will see how it changes the value for other columns. as its supposed to do

    now click on the creation date column and sort from AtoZ or old to new. now try changing the option in the Stage column say from won to lost. and you will understand exactly what i mean



    thanks in advance to whom ever solves this


    Cheers!
    Attached Files Attached Files
    Last edited by joe313; 07-02-2020 at 05:21 AM. Reason: attachement

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: columns not sorting correctly

    Welcome to the forum.

    I am guessing that you have used forumae such as =Sheet1!A2 in those assocaieted columns, and that will be your issue, if so.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,219

    Re: columns not sorting correctly

    In your probability formulas your references include the name of the sheet that the formulas are on. Change this part:

    MATCH('Sales Pipeline'!A7

    to this:

    MATCH(A7

    and the sorting should work properly.
    Rory

  4. #4
    Registered User
    Join Date
    07-01-2020
    Location
    Qatar
    MS-Off Ver
    365
    Posts
    3

    Re: columns not sorting correctly

    rorya, Thank you for the simple and amazing solution. worked like a charm

  5. #5
    Registered User
    Join Date
    07-01-2020
    Location
    Qatar
    MS-Off Ver
    365
    Posts
    3

    Re: columns not sorting correctly

    thank you AliGW for the help! got sorted with rorya suggestion

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: columns not sorting correctly

    Glad you got there. Thanks for letting us know.

+ 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. dates not sorting correctly
    By Winoc in forum Excel General
    Replies: 5
    Last Post: 07-23-2019, 08:36 AM
  2. [SOLVED] Power Query Sorting by Date not sorting correctly
    By kersplash in forum Excel General
    Replies: 5
    Last Post: 08-20-2018, 02:59 AM
  3. [SOLVED] Sorting numbers... correctly
    By LonesomeJoe in forum Excel General
    Replies: 6
    Last Post: 06-11-2014, 04:59 PM
  4. numbers not sorting correctly
    By JMTMayor in forum Excel General
    Replies: 15
    Last Post: 08-01-2013, 12:00 PM
  5. sorting not working correctly
    By jjbigfish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2012, 02:46 PM
  6. [SOLVED] Date not sorting correctly....
    By DeeLaa77 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-28-2012, 08:50 AM
  7. Not sorting correctly
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2008, 03:48 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