Count the each element in an array

[JohnSmith]

I have an array and when I display the array, it looks like this:

Group1
Dave
John
Dave
Mike
Mike
Leo
Amos
Brian
Dave

I want to have it displayed like this:

Group1
Dave 3
John 1
Mike 2
Leo 1
Amos 1
Brian 1

Here is my code at the moment to display as in the first example:

<u>Group1</u><br>
<%for i=1 to Var10%>
<%=Var10P(i)%><br>
<%next%>

[simonm]

Can you use a database?

Insert the values of the array into a table and then do a GroupBy query to count the number of occurences of each name.

[JohnSmith]

I prefer not to use a database...

[James Stanich]

You could do it with two arrays...

Loop eveyname in your primary array.

Create/update an array with the counts of names...

Sya "BOB" is the current arry entry. Loop thru the second arry trying to find "BOB". If it's not in there, add the name with COUNT of 1, if it is in there, add to the count.

Note : If alot of names, this will be slow. Suggest using database, too.