Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to pair each item on one list to each item on another list
I need to pair each item on one list to each item on another list. For
example, if I have a list: A B C And another list: D E F What I need is one list as follows: AD AE AF BD BE BF CD CE CF Is there a simple way to do this, instead of a lot of copy and paste? Thanks! Peter R. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to pair each item on one list to each item on another list
Assuming the 2 lists are housed within A1:B3, viz:
A D B E C F Put in C1: =OFFSET($A$1,INT((ROW(A1)-1)/3),)&OFFSET($B$1,MOD(ROW(A1)-1,3),) Copy down to C9 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Peter R." wrote: I need to pair each item on one list to each item on another list. For example, if I have a list: A B C And another list: D E F What I need is one list as follows: AD AE AF BD BE BF CD CE CF Is there a simple way to do this, instead of a lot of copy and paste? Thanks! Peter R. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list/typing item from list error | Excel Worksheet Functions | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
Extract each item in the list | Excel Worksheet Functions | |||
How select an item in a list box | Excel Worksheet Functions | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |