+ Reply to Thread
Results 1 to 2 of 2

Sorting while keeping data together

  1. #1
    Registered User
    Join Date
    San Antonio, TX
    MS-Off Ver

    Sorting while keeping data together

    We have a spreadsheet with approximately 800 rows of data. We need to keep member ids together, but have the names in alphabetical order. If I sort alphabetically some children don't have the same last name, but need to be in a row below their parent. If I sort by employee id then all employees are out of order.....

    Column Headers:
    Last Name First name Relationship Code Employee ID

    Any and all help appreciated.

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver
    Microsoft 365 aka Office 365

    Re: Sorting while keeping data together

    Hi trmm and welcome to ExcelForum,

    Try adding a helper column that contains the primary name used to sort (i.e. the name of the Parents). Optionally add a number after the name so each family would sort in the order you prefer. The column can be hidden when not used for sorting if it would ruin your PrettyPrint.


+ 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. keeping the first empty row in a table after sorting the data
    By boboivan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2015, 03:16 PM
  2. Replies: 0
    Last Post: 01-25-2015, 05:41 AM
  3. [SOLVED] Sorting A Filter...Not keeping data the same
    By buddha in forum Excel General
    Replies: 2
    Last Post: 03-16-2013, 01:21 PM
  4. Sorting while keeping 2 columns of grouped data together
    By jenny8220 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2012, 05:53 PM
  5. Sorting & keeping data intact?
    By elfiky in forum Excel General
    Replies: 1
    Last Post: 03-24-2009, 04:38 PM


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