| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging different sheets
hello everybody,
I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS .... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 .... .... and I want to create in a new sheet the following set of data Payment Date Type Activity 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 16/02/2010 XS Activity1 16/02/2010 XS Activity2 16/02/2010 XS Activity3 ..... ... ... I tried several combinations between offset, match, countif but nothing is working. I would appreciate any help thank you vassilis |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merging different sheets
What rules apply? How do the records on the 1st sheet associate with the
2nd sheet? Or how do you know which date goes where on the 2nd sheet? Dennis "vassilis" wrote in message ... hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS ... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 ... .... and I want to create in a new sheet the following set of data Payment Date Type Activity 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 16/02/2010 XS Activity1 16/02/2010 XS Activity2 16/02/2010 XS Activity3 .... ... ... I tried several combinations between offset, match, countif but nothing is working. I would appreciate any help thank you vassilis |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merging different sheets
thank you for your question...
the common key in the two sheets is the "type", i.e. XS, LS, etc. I named it in the 2nd sheet as "task" but actually is the same as type. So in the 1st sheet you have the payment date and the type of the financial instrument and in the 2nd you have the activities associated with each type of instrument. so the new table should be composed of the two tables. for example the 1st 3 rows of the new table refer to the 1st payment on 15/2/2010 which is presented 3 times as "XS" has 3 different activities please come back to me if it is still not clear, much appreciated "Dennis Tucker" wrote: What rules apply? How do the records on the 1st sheet associate with the 2nd sheet? Or how do you know which date goes where on the 2nd sheet? Dennis "vassilis" wrote in message ... hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS ... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 ... .... and I want to create in a new sheet the following set of data Payment Date Type Activity 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 16/02/2010 XS Activity1 16/02/2010 XS Activity2 16/02/2010 XS Activity3 .... ... ... I tried several combinations between offset, match, countif but nothing is working. I would appreciate any help thank you vassilis . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merging different sheets
Does each payment date with the TYPE(XS) get Activity1, Activity2 and
Activity3? Does each payment date with the TYPE(LS) get Activity4 and Activity5? "vassilis" wrote in message ... thank you for your question... the common key in the two sheets is the "type", i.e. XS, LS, etc. I named it in the 2nd sheet as "task" but actually is the same as type. So in the 1st sheet you have the payment date and the type of the financial instrument and in the 2nd you have the activities associated with each type of instrument. so the new table should be composed of the two tables. for example the 1st 3 rows of the new table refer to the 1st payment on 15/2/2010 which is presented 3 times as "XS" has 3 different activities please come back to me if it is still not clear, much appreciated "Dennis Tucker" wrote: What rules apply? How do the records on the 1st sheet associate with the 2nd sheet? Or how do you know which date goes where on the 2nd sheet? Dennis "vassilis" wrote in message ... hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS ... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 ... .... and I want to create in a new sheet the following set of data Payment Date Type Activity 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 16/02/2010 XS Activity1 16/02/2010 XS Activity2 16/02/2010 XS Activity3 .... ... ... I tried several combinations between offset, match, countif but nothing is working. I would appreciate any help thank you vassilis . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merging different sheets
Also, would it be better to list these things like this...
15/02/2010 XS Activity1 Activity2 Activity3 15/02/2010 LS Activity4 Activity5 16/02/2010 XS Activity1 Activity2 Activity3 Are these dates in DD/MM/YYY format? "vassilis" wrote in message ... thank you for your question... the common key in the two sheets is the "type", i.e. XS, LS, etc. I named it in the 2nd sheet as "task" but actually is the same as type. So in the 1st sheet you have the payment date and the type of the financial instrument and in the 2nd you have the activities associated with each type of instrument. so the new table should be composed of the two tables. for example the 1st 3 rows of the new table refer to the 1st payment on 15/2/2010 which is presented 3 times as "XS" has 3 different activities please come back to me if it is still not clear, much appreciated "Dennis Tucker" wrote: What rules apply? How do the records on the 1st sheet associate with the 2nd sheet? Or how do you know which date goes where on the 2nd sheet? Dennis "vassilis" wrote in message ... hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS ... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 ... .... and I want to create in a new sheet the following set of data Payment Date Type Activity 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 16/02/2010 XS Activity1 16/02/2010 XS Activity2 16/02/2010 XS Activity3 .... ... ... I tried several combinations between offset, match, countif but nothing is working. I would appreciate any help thank you vassilis . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merging different sheets
Hi Dennis,
thank you for your question. The format of the dates is indeed DD/MM/YYY. Each Payment indeed should be linked with the respective activities. Regarding your last comment itwould be better to have the data in colum format, i.e. 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 and so on because i want to run a pivot. Do you want me to send you an excel file with real data so that we have a better idea? really appreciate your effort thanks Vassilis "Dennis Tucker" wrote: Also, would it be better to list these things like this... 15/02/2010 XS Activity1 Activity2 Activity3 15/02/2010 LS Activity4 Activity5 16/02/2010 XS Activity1 Activity2 Activity3 Are these dates in DD/MM/YYY format? "vassilis" wrote in message ... thank you for your question... the common key in the two sheets is the "type", i.e. XS, LS, etc. I named it in the 2nd sheet as "task" but actually is the same as type. So in the 1st sheet you have the payment date and the type of the financial instrument and in the 2nd you have the activities associated with each type of instrument. so the new table should be composed of the two tables. for example the 1st 3 rows of the new table refer to the 1st payment on 15/2/2010 which is presented 3 times as "XS" has 3 different activities please come back to me if it is still not clear, much appreciated "Dennis Tucker" wrote: What rules apply? How do the records on the 1st sheet associate with the 2nd sheet? Or how do you know which date goes where on the 2nd sheet? Dennis "vassilis" wrote in message ... hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS ... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 ... .... and I want to create in a new sheet the following set of data Payment Date Type Activity 15/02/2010 XS Activity1 15/02/2010 XS Activity2 15/02/2010 XS Activity3 15/02/2010 LS Activity4 15/02/2010 LS Activity5 16/02/2010 XS Activity1 16/02/2010 XS Activity2 16/02/2010 XS Activity3 .... ... ... I tried several combinations between offset, match, countif but nothing is working. I would appreciate any help thank you vassilis . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging sheets | Excel Discussion (Misc queries) | |||
| Merging sheets | Excel Worksheet Functions | |||
| merging sheets | Excel Worksheet Functions | |||
| merging sheets | Excel Discussion (Misc queries) | |||
| merging sheets | Excel Worksheet Functions | |||
Linear Mode
