Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to combine items in 3 columns and produce all combinations usi
like a table
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to combine items in 3 columns and produce all combinations usi
nest 3 loops. Each loop loops over the values in one of the columns.
-- Regards, Tom Ogilvy "Kumar_KP" wrote in message ... like a table |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to combine items in 3 columns and produce all combinations usi
Dim rw as Long, col as Long
dim cellA as Range, cellB as Range dim cellC as Range rw = 1 col = 5 for each cellA in Range("A1:A10") for each cellB in Range("B1:B15") for each cellC in Range("C1:C8") cells(rw,col).value = CellA cells(rw,col+1).value = CellB cells(rw,col+2).value = CellC rw = rw + 1 if rw 60000 then rw = 1 col = col + 4 end if Next Next Next -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "kumar" wrote in message u... pls can you explain how to do it?? "Tom Ogilvy" wrote in message ... nest 3 loops. Each loop loops over the values in one of the columns. -- Regards, Tom Ogilvy "Kumar_KP" wrote in message ... like a table |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to combine items in 3 columns and produce all combinations usi
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "Kumar_KP" schrieb im Newsbeitrag ... like a table |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to combine items in 3 columns and produce all combinations usi
pls can you explain how to do it??
"Tom Ogilvy" wrote in message ... nest 3 loops. Each loop loops over the values in one of the columns. -- Regards, Tom Ogilvy "Kumar_KP" wrote in message ... like a table |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
line up items in column a with items in columns b, c, etc | Excel Discussion (Misc queries) | |||
Counting unique combinations in two columns | Excel Discussion (Misc queries) | |||
Like items will not combine in a pivot table. | Excel Worksheet Functions | |||
produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
How do I combine four data items into one in a Pivot Table? | Excel Discussion (Misc queries) |