#1




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; 12132013 at 09:50 PM. 
#2




Re identifying the differences between the columns
You aksed how to identify people who werent in either of the 2 conferences. Do you mean people who went to one conference but not the other ? If you do then a conditional format will do the trick Use the "use a formula to determine wich cells to format" enter the following formula for the Column A cells . Formula will show people in column A who did not attend the Column B conference =ISNA(VLOOKUP(A2,B:B,1,FALSE)) and select a format enter the following formula for the Column B cells . Formula will show people in column B who did not attend the Column A conference =ISNA(VLOOKUP(B2,A:A,1,FALSE)) and select a format (by the way this worls regardless of whether the columns are sorted or not) 
#3




Your second question is easier, officeboy. I'm assuming you have a list of all names in a main worksheet—let's call it "Index"—because if you don't you're up the proverbial creek. But assuming you have a master list, one solution is in the sample I'm uploaded. There are other ways to format the results, and probably other ways to generate them (Pecoflyer is especially adept with alternatives that I'm not yet used to), but this is one way.
By the way, in creating that sample I had to generate some random names. I was going to pull them off any random database—IMDb, perhaps—but ran across this site instead, which generated random names for me just by asking. Very cool, and I plan to bookmark it for repeat visits. Now back to your first question, which I left for later because I don't understand it. If you have one column, you can certainly "split" it (in a sense) by creating one next to it. And certainly the two columns could have different widths. But they wouldn't be upper/lower columns; one would be to the left and the other to the right. I figure I must have misunderstood the question. 
#4




Thx Bob!
Yeah, I meant splitting one column e.g. "A" so that the new ones are, say, "A1" & "A2" with A2 below A1, and the widths of them can be adjusted independently without affecting the other. I did not describe my question clear enough. It has been modified with regard to this. Last edited by officeboy09; 12142013 at 02:38 AM. 
#5




Could you please post a sample sheet showing BEFORE and AFTER ? Thx (no pics pse)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
#6




I don't think he can post a sample, Peco, because he's asking whether it's possible to do it at all. If he could show us what he wants to accomplish, it would only be by having already figured out how to accomplish it.
Officeboy, I still have a problem with the description. Since a column is vertical in nature, it's not possible to split it and then have two columns one above the other. By their nature, two columns must be to the left and right; just as it would be impossible to split a row and arrange the two rows left and right of each other. But maybe you mean you want to split a single cell into two (so to speak) subcells, one above the other? You can do that in Word tables; maybe you're hoping to do it in Excel too? If so, I'm going to offer the opinion that while it's practical in Word, it can never be in Excel, for the simple reason that there's no workable scheme for addressing such arrangements. You say you could split A1 into A1 and A2. Presumably the other cells on the row would remain B1, C1 and so on. But how would you refer to the second row? If "A2" now means the second subcell in the first row, how do you refer to the cell on the second row in column A? Should that cell be A3, while all the other cells on that row continue as B2, C2 and so on? Of course not, you say; you just refer to the whole row as A3, B3, C3 and so on; and there needn't be any B2, C2 etc at all. And in that case, you can indeed do what you want, though it's a workaround. Insert a new row after row 1. Merge cells B1 and B2, C1 and C2, D1 and D2 and so on, leaving A1 and A2 unmerged. Now you have what you're asking about (if I guessed correctly). As for giving one cell a different width than the other cells in the same column: The objections are similar, and so is the workaround. If for presentation purposes (you wouldn't want to do this otherwise) you want to extend some cells' width into adjacent columns, you can do it—rather you can pretend to do it—by merging cells horizontally. See the attached sample. But I wouldn't call it a convenient method. 
#7




The simple answer is that, in Excel, a column cannot have different widths for different rows and you can't split a cell horizontally (i.e. one part above the other). Bob has posted a workaround that may suit. FWIW Word tables can have both attributes.
__________________
Cheers, Paul Edstein [Fmr MS MVP  Word] 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Adjusting column widths  norwood  Word VBA  0  09242013 06:53 AM 
VBA code to fix column widths  molesy  Excel  3  09162013 12:51 PM 
Alternate Table Column Widths on even and odd pages  robrastelli  Word  4  08082012 07:33 PM 
Altering Column Widths on Two Col Page  abrogard  Word  2  12302010 06:03 AM 
Seperate Column widths in one worksheet  miller.3276  Excel  2  01272010 02:12 PM 