Summing Like Element Array Values
 

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

Summing Like Element Array Values
 

have you thought of using a collection instead?

also, be sure that the key is the last + "!" + first, not just last-first.

Collections are faster to work with than arrays and it is instantly obvious
whether something is in a collection (just look for a trappable error when
trying to ad to it!) instead of looping through an array's elements.

HTH...
Bill
"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

Summing Like Element Array Values
 

Before you add the item to the array you could compare the item to be
added to each element in the array by looping through the array. If
the match for both first and last name is found then reassign the third
element to the current value plus the new value.
If there is no match then you can add each item to the array.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=379786

Summing Like Element Array Values
 

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