+ Reply to Thread
Results 1 to 4 of 4

Sort function - line integrity compromised

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    New York, New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Sort function - line integrity compromised

    Background: I have an excel spreadsheet that I use to track customer interest in certain products that I sell. I have one column for the date I spoke with the customer, a second column to track which customer indicated the interest, a third to indicate what product they were interested in, and a fourth column for brief call notes. I use the sort function to sort the data by date to see what products customers were most interested in recently. I also sort by customer so that I can review all the products that the customer considered in the past.

    Problem: When sorting, I have been highlighting all the cells in question, but for some reason, excel is not honoring the integrity of the data in the line. When I sort, I expect that all of the data that is in line L to stay together in one line. Instead, the integrity of the line is violated. The result is that the dates of the calls no longer match the customers whom I spoke with (i.e. the date in line L that used to be paired with the rest of the info in line L is no longer matched with line L).

    Can anyone tell me the following:
    1) How can I fix/avoid this problem?
    2) Is there any way to recover "line integrity" after it has become jumbled?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Sort function - line integrity compromised

    Welcome to the forum.

    I have never seen that occur when all appropriate columns are selected. Do you have merged cells?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-22-2009
    Location
    New York, New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Sort function - line integrity compromised

    Yes, I definitely had all lines/cells highlighted. It's very puzzling how it could possibly happen, but it does.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Sort function - line integrity compromised

    Hmm.

    I'd have to see it to believe it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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