Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (97 sr -2)

    I don't see a file, but you can select all data you want to keep together and then sort by one column (e.g. names). The rows will stay together. Be sure there are no empty cells in the names column, that is, repeat the names if necessary.

  2. #2
    New Lounger
    Join Date
    Sep 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting (97 sr -2)

    I am trying to sort based on "groups of data" for example a name would have 5 rows of data associated with it. (see file). I would like to keep the data with the associated names and sort the names alphabetically. Can anyone help me out?

    TIA
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (97 sr -2)

    Thanks. I have attached the file.

    I do have blanks in the name column and can not repeat the names (a requirement of my user).

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sorting (97 sr -2)

    If you wish to sort the records based on name , then each record must have name field with an entry. If you just want th efirst instance of any given name to be visible I would suggest that you use conditional formatting. Apply the following conditional formatting to A2 and copy it down the column.

    If Cell Value is equal to =$A1

    and format the text the same color as the background. Then only the first instance of the name will be visible, but the name will be included for sorting purposes in the normal manner.

    I attach your workbook with that formatting applied to cells up to A200.

    Andrew C
    Attached Files Attached Files

  5. #5
    New Lounger
    Join Date
    Sep 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (97 sr -2)

    Thank you I will try it!! <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

Posting Permissions

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