View Single Post
 
Old 12-13-2013, 06:28 PM
officeboy09 officeboy09 is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default Splitting one column into two with two different widths

Is it possible to horizontally split one column into two new columns in vertical connection (not adjacent) so that the lower/upper column width can be changed without changing the width of the other?

Also, that if there are two groups of people namely A & B. People in group A attended a company conference in September and people in group B attended the conference in December.

There are hundreds of them.

I placed the names of group A people in column "Conference Sep" and group B in column "Conference Dec" respectively, and sorted them in alphabetical order by their surnames.

I need to identify which people were not in either of these conferences. Is there any way in excel to automatically highlight the difference between these two columns?

Last edited by officeboy09; 12-13-2013 at 09:50 PM.
Reply With Quote