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