Consolidate data in an 2-dimension array in VBA
 

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


--
Huyeote
------------------------------------------------------------------------
Huyeote's Profile: http://www.excelforum.com/member.php...o&userid=13894
View this thread: http://www.excelforum.com/showthread...hreadid=477016