Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Merge two lists
I have 2 sets of data range i.e set1 from range [Sheet1!A1:A32] and set2 is
from [Sheet2!B1:B32] Set1 contains Vegetables List Set2 contains Fruits List Now I want to merge both lists in [Sheet3! C1:C64] but one value from set1 and one value from set2 Below is graphical translation: SET1 A1: Tomatto A2: Cucummber A3: Carrott ...............so on SET2 B1: Apple B2: Oranges B3: Bananna ...............so on SET3 [to create] C1: Tomatto C2: Apple C3: Cucummber C4: Oranges C5: Carrott C6: Bananna ...............so on Please help |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Merge two lists
If indeed the sheets are called 1 and 2 you can use this in C1 and copy down
=OFFSET(INDIRECT("'Sheet"&MOD(ROW(2:2),2)+1&"'!A1" ),FLOOR(ROW(2:2)/2,1)-1,MOD(ROW(2:2),2)) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Murtaza" <NoEmail@NoEmail wrote in message ... I have 2 sets of data range i.e set1 from range [Sheet1!A1:A32] and set2 is from [Sheet2!B1:B32] Set1 contains Vegetables List Set2 contains Fruits List Now I want to merge both lists in [Sheet3! C1:C64] but one value from set1 and one value from set2 Below is graphical translation: SET1 A1: Tomatto A2: Cucummber A3: Carrott ..............so on SET2 B1: Apple B2: Oranges B3: Bananna ..............so on SET3 [to create] C1: Tomatto C2: Apple C3: Cucummber C4: Oranges C5: Carrott C6: Bananna ..............so on Please help |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Merge two lists
Thanks Peo!
"Peo Sjoblom" wrote in message ... If indeed the sheets are called 1 and 2 you can use this in C1 and copy down =OFFSET(INDIRECT("'Sheet"&MOD(ROW(2:2),2)+1&"'!A1" ),FLOOR(ROW(2:2)/2,1)-1,MO D(ROW(2:2),2)) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Murtaza" <NoEmail@NoEmail wrote in message ... I have 2 sets of data range i.e set1 from range [Sheet1!A1:A32] and set2 is from [Sheet2!B1:B32] Set1 contains Vegetables List Set2 contains Fruits List Now I want to merge both lists in [Sheet3! C1:C64] but one value from set1 and one value from set2 Below is graphical translation: SET1 A1: Tomatto A2: Cucummber A3: Carrott ..............so on SET2 B1: Apple B2: Oranges B3: Bananna ..............so on SET3 [to create] C1: Tomatto C2: Apple C3: Cucummber C4: Oranges C5: Carrott C6: Bananna ..............so on Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge two lists to get one with unique records | Excel Discussion (Misc queries) | |||
compare and merge lists in separate worksheets | Excel Worksheet Functions | |||
help with vlookup to merge two lists | Excel Discussion (Misc queries) | |||
Merge/Combine address lists | Excel Worksheet Functions | |||
How can I merge different lists in Excel? | Excel Discussion (Misc queries) |