A collection of arrays might be the best solution, but what if there are
people
with the same first name and surname or was that just a simplified example?

RBS


"DMS" wrote in message
...
All,

I am trying to come up with a way to identify and then sum like Elements
in
an Array.

For Example, Lets Say I have an array that contains the following items
1.First Name
2.Last Name
3.Hours worked

The Macro I am witing is adding this type of data to an Array, but I don't
want there to be duplicate array items for the same First and Last Name.

So lets say the first item in my Array is John, Smith, 20. Before I add
the
next item to the Array, I want to make sure that the First and Last name
aren't already in the Array, if it is already in the Array, then it should
add the hours to the existing Array item.

Or, is there a way to sum like elements after an Array is created?

Thanks for your help.

DMS