Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I line up 2 columns with similar information?
I have 2 columns with names in each and I'd like to line them up next to each
other. |
#2
|
|||
|
|||
How can I line up 2 columns with similar information?
I think we'll need more information, Kathy. I don't understand what you're
trying to do. Can you give exactly what's up? ************ Anne Troy www.OfficeArticles.com "Kathy" wrote in message ... I have 2 columns with names in each and I'd like to line them up next to each other. |
#3
|
|||
|
|||
How can I line up 2 columns with similar information?
Column A has employee number, Column B has the same employee numbers but has
additional employee numbers, and Column C has employee social security numbers. If column A and B have the same number, line them up and if not put in a blank cell. Hopefully that makes sense. "Anne Troy" wrote: I think we'll need more information, Kathy. I don't understand what you're trying to do. Can you give exactly what's up? ************ Anne Troy www.OfficeArticles.com "Kathy" wrote in message ... I have 2 columns with names in each and I'd like to line them up next to each other. |
#4
|
|||
|
|||
How can I line up 2 columns with similar information?
Hi Kathy
On another Sheet, Sheet2, copy all of Sheet1 Column B to Sheet2 Column A as this column contains the most names. On Sheet2 in cell B1 enter =IF(ISERROR(VLOOKUP(A1,Sheet1!A:A,1,0)),"",VLOOKUP (A1,Sheet1!A:A,1,0)) On Sheet2 in cell C1 enter =IF(ISERROR(VLOOKUP(A1,Sheet1!A:A,3,0)),"",VLOOKUP (A1,Sheet1!A:A,3,0)) Copy down for the maximum number of rows in column A of Sheet2 Once complete, copy the complete range of data and Paste SpecialValues over the top of the 3 columns to "fix" the data. You can then delete Sheet1 once you are satisfied that all of the data has come across successfully. Regards Roger Govier Kathy wrote: Column A has employee number, Column B has the same employee numbers but has additional employee numbers, and Column C has employee social security numbers. If column A and B have the same number, line them up and if not put in a blank cell. Hopefully that makes sense. "Anne Troy" wrote: I think we'll need more information, Kathy. I don't understand what you're trying to do. Can you give exactly what's up? ************ Anne Troy www.OfficeArticles.com "Kathy" wrote in message ... I have 2 columns with names in each and I'd like to line them up next to each other. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help comparing data and returning information... | Excel Worksheet Functions | |||
Regarding Sorting Columns | Excel Discussion (Misc queries) | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |