+ Reply to Thread
Results 1 to 2 of 2

Sorting while keeping data together

  1. #1
    Registered User
    Join Date
    04-17-2015
    Location
    San Antonio, TX
    MS-Off Ver
    2010
    Posts
    1

    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
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    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.

    Lewis

+ 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

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