Sorting Grouped Info

[Dendrinos2]

I have data that needs to be alphabatized but in this situation I have a company name then a bunch of subsidiaries listed underneath the company that are stored in a group. I need to alphabatize the company while keeping the subsidiaries in place under that company. When I do a regular sort excel does not recognize that these things need to stay grouped. Any help?

[martindwilson]

hmm matbe a sample work book? how do we determine company name from subsidiary

[Dendrinos2]

I have color coded them

[shg]

The easy way (and the way to implement a database in Excel) is to put company names in col A (duplicated as necessary), and subsidiaries in col B. Then sort in the normal way.

[martindwilson]

colour coding in excel is probably not the best idea but you can sort on colour in excel 2010,anyway shg lives next door so maybe a beer or two? lol

[shg]

Dendrinos, please take a few minutes to read the forum rules about cross-posting.

Thanks.