Count Duplicates from VBA Array?

[Legacy 174215]

Hi.

I currently have an array and I want to count the number of duplicates in this array, but I'm not sure exactly the best approach for this.

Current Array
Array: arry(i,count)

arry(1,count) = 'ISB2-01"
arry(2,count) = 'ISB2-01"
arry(3,count) = 'ISB2-02"
arry(4,count) = 'ISB2-02"
arry(4,count) = 'ISB2-02"
arry(5,count) = 'ISB2-03"

New Array Result (this is what I want to end up with)

newarry(string,count) = newarry("ISB2-01",2)
newarry(string,count) = newarry("ISB2-02",3)
newarry(string,count) = newarry("ISB2-03",1)


I know this is pretty easy but I can't rap my head around it to get this.

 

[DonkeyOte]

x-posted with suggestion/solution c/o Colin Legg:

http://www.excelforum.com/excel-programming/767238-count-duplicates-from-vba-array.html