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.....
Last Name First name Relationship Code Employee ID
Any and all help appreciated.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By boboivan in forum Excel Programming / VBA / Macros
Last Post: 01-25-2015, 03:16 PM
By boboivan in forum Excel General
Last Post: 01-25-2015, 05:41 AM
By buddha in forum Excel General
Last Post: 03-16-2013, 01:21 PM
By jenny8220 in forum Excel Formulas & Functions
Last Post: 01-23-2012, 05:53 PM
By elfiky in forum Excel General
Last Post: 03-24-2009, 04:38 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1