Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List feature (2003)

    I have a user who created a spreadsheet and used the Data/List/Create List feature. Since she has done this, it will not sort correctly. It will only sort by last name not last name and then first name.

    I am at a lost. I have tried converting to a range and still nothing. The unlink list is not available.
    Please help!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List feature (2003)

    I apologize for the lack of replies. Apparently nobody has a clue. Perhaps you could post a small sample workbook that demonstrates the problem, so that Loungers can investigate it. Replace sensitive data with dummy data.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List feature (2003)

    By the way, I cannot reproduce the problem. When I create a list using Data | List | Create List, I can sort it any way I want using Data | Sort..., using the Sort Ascending and Sort Descending toolbar buttons and the corresponding items in the dropdown menus in the column headers.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List feature (2003)

    I appreciate the continued search for my answer. Attached is the spreadsheet. I can sort either by last or first but not by both. Pay attention to the list of Adams. If you use the filter, it will only allow you to sort one column not a multiple column sort.
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List feature (2003)

    The problem is that some of the last names have a space after them. Excel sorts <code>"Adams "</code> after <code>"Adams"</code>. If you remove the trailing spaces, the data will sort correctly.

  6. #6
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List feature (2003)

    You have got to be kidding me [img]/forums/images/smilies/smile.gif[/img]

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List feature (2003)

    You can run this short macro to remove leading and trailing spaces from all cells with text:

    Sub TrimThoseSpaces()
    Dim oCell As Range
    For Each oCell In ActiveSheet.UsedRange
    If Not oCell.HasFormula And Application.WorksheetFunction.IsText(oCell) Then
    oCell = Trim(oCell)
    End If
    Next oCell
    End Sub

  8. #8
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List feature (2003)

    Thanks...you do not know how many countless and unproductive hours I have spent on this spreadsheet. As an IT helpdesk manager, you think that I would not assume that the user keyed in the data correctly.

    I will use the macro and actually have it run when the spreadsheet is opened.

    One more question, I have another spreadsheet that is shared between users. When one user is entering in numbers, Excel will automatically add a row above the total. If you add another number, another row is inserted. Under Tools/Shared workbook, the option is checked to allow changes...if I remove the check, it does not insert the additional rows. Is this the reason it is adding rows? I tried to remove some data so I could attach, but it will not allow me to delete the other spreadsheets in the workbook and if I copy the one, it does not do it.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List feature (2003)

    I strongly recommend *not* to use the Share Workbook feature. Excel is not good at this, and it can easily cause your workbook to become corrupt.
    If the workbook is not shared, only one user can edit it at a time; other users get a warning with an option to be notified when the workbook is available for editing again.
    If you really need multi-user capability, think about using Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •