Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Append One Array to Another, and Consolidate
I have two arrays, both of which are two-dimensional (for example,
Array1(100,5) and Array2(300,5), of the same type (Variant). I want to combine them into a single array, and then I want to consolidate any duplicate elements. Any ideas on the best way to do this? In the past, I've handled this by just dumping the data from the arrays onto a blank worksheet, sorting the data there, and then doing a search loop that consolidates the duplicate elements. I'm thinking there might be a way to do it entirely within arrays, off the worksheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to append to file using an array | Excel Programming | |||
Append data from a column to separate table array | Excel Programming | |||
Consolidate data in an 2-dimension array in VBA | Excel Programming | |||
how to know which row to append for the last row | Excel Programming | |||
Qn: How to Append??? | Excel Programming |