Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 questions, one difficult.
When I open an Excel - by default I see 3 workseets. My question:
I have 3 separate excel files. How to create from 3 excel files one file with 3 worksheets? I have 3 excel woksheets - A1, A2, A3. Each of them have a column called SSN. I want to add to a new column to A1 with the following walues: if SSN from A1 exist in A2 - the value will be "A2" if SSN from A1 exist in A3 - the value will be "A3" if SSN from A1 does not exist in A2 and A3 - the value will be "N" Can you give me a hint how to do it? Thanks, Zalek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 questions, one difficult.
=IF(A2!A1="SSN","A2",IF(A3!A1="SSN","A3","N"))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "zalek" wrote in message ups.com... When I open an Excel - by default I see 3 workseets. My question: I have 3 separate excel files. How to create from 3 excel files one file with 3 worksheets? I have 3 excel woksheets - A1, A2, A3. Each of them have a column called SSN. I want to add to a new column to A1 with the following walues: if SSN from A1 exist in A2 - the value will be "A2" if SSN from A1 exist in A3 - the value will be "A3" if SSN from A1 does not exist in A2 and A3 - the value will be "N" Can you give me a hint how to do it? Thanks, Zalek |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 questions, one difficult.
In new column drag down this formula:
=IF(COUNTIF('A2'!A1:A50,A1),"A2",IF(COUNTIF('A3'!A 1:A50,A1),"A3","N")) see Ron's site about Copy/paste from workbooks: http://www.rondebruin.nl/tips.htm Mike F "zalek" wrote in message ups.com... When I open an Excel - by default I see 3 workseets. My question: I have 3 separate excel files. How to create from 3 excel files one file with 3 worksheets? I have 3 excel woksheets - A1, A2, A3. Each of them have a column called SSN. I want to add to a new column to A1 with the following walues: if SSN from A1 exist in A2 - the value will be "A2" if SSN from A1 exist in A3 - the value will be "A3" if SSN from A1 does not exist in A2 and A3 - the value will be "N" Can you give me a hint how to do it? Thanks, Zalek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
2 questions, 1 easy about "" in VB, 1 very difficult | Excel Programming | |||
Too difficult for me, please help. | Excel Worksheet Functions | |||
Is this difficult??? | Excel Programming |