Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort 2 or more rows of cells linked to one row of data
I have a spread sheet with multiple rows of data. All of these rows have
several additional cells in seperate rows. Looks a little like this: 1 Session 1 Mary Company ABC Company XYZ 2 Session 2 John Company QRS Company TUV I need to sort alphabeticaly by Company while keeping the Companies linked to the appropriate sessions. Is there a way to do this? Or if I merge the companies into one cell can I still sort alphabetically? Please help!! |
#2
|
|||
|
|||
I'd do something like what's described he
http://www.contextures.com/xlCondFor...html#Duplicate You'll need to have data in this form though: 1 Session 1 Mary Company ABC 1 Session 1 Mary Company XYZ 2 Session 2 John Company QRS 2 Session 2 John Company TUV "Magdalena" wrote in message ... I have a spread sheet with multiple rows of data. All of these rows have several additional cells in seperate rows. Looks a little like this: 1 Session 1 Mary Company ABC Company XYZ 2 Session 2 John Company QRS Company TUV I need to sort alphabeticaly by Company while keeping the Companies linked to the appropriate sessions. Is there a way to do this? Or if I merge the companies into one cell can I still sort alphabetically? Please help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort with multiple header rows | Excel Discussion (Misc queries) | |||
getting msg: cannot sort merged cells not same size | Excel Discussion (Misc queries) | |||
How to determine which rows contain slected cells in a multiple c. | Excel Worksheet Functions | |||
How do I sort by complete rows in excell | Excel Worksheet Functions | |||
Thumbnail pictures in cells don't sort with rest of row | Excel Discussion (Misc queries) |