| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet equivalent of VBA Union?
Tom Hopefully I am not overlooking the obvious. I think u r... name kolA = a1:a10 name kolB = b1:b10 name kolAB = =(kolA;kolB) name kolABC = (a1:a10;b1:b10;c1:c10) works in formulas that accept multiarea ranges keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Tom Ogilvy" wrote: =CHOOSE({1,2},MyRangeColA,MyRangeColC) Entered as an array formula is about as close as I could come. This builds a two dimensional array, not really a union. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA equivalent for worksheet 'match'? | Excel Discussion (Misc queries) | |||
| union range | Excel Discussion (Misc queries) | |||
| Equivalent of Minus in Excel. Also Union, Intersect. | Excel Worksheet Functions | |||
| UNION of Arrays - is possible? | Excel Discussion (Misc queries) | |||
| Help w/ Union Queries | Excel Discussion (Misc queries) | |||
Threaded Mode
