H
Huyeote
Hi there,
Can anyone show me a quick way to consolidate data in a 2-dimension
array in VBA. I have got an array in VBA with multiple appearance of
some identifiers. The array looks like...
"A", 1, 2
"B", 2, 3
"A", 3, 4
"C", 4, 5
I would like a function to consolidate the data and return an array
with data like
"A", 4, 5
"B", 2, 3
"C", 4, 5
In the consolidated array, the identifiers will have only one
appearance.
The array only exists in memory within a procedure. So I can't use
Consolidate method which only works on range.
Thanks,
Huyeote
Can anyone show me a quick way to consolidate data in a 2-dimension
array in VBA. I have got an array in VBA with multiple appearance of
some identifiers. The array looks like...
"A", 1, 2
"B", 2, 3
"A", 3, 4
"C", 4, 5
I would like a function to consolidate the data and return an array
with data like
"A", 4, 5
"B", 2, 3
"C", 4, 5
In the consolidated array, the identifiers will have only one
appearance.
The array only exists in memory within a procedure. So I can't use
Consolidate method which only works on range.
Thanks,
Huyeote