Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values from array | Excel Worksheet Functions | |||
array functions and complex element values | Excel Worksheet Functions | |||
Set array element to empty | Excel Programming | |||
Further Array Element question | Excel Programming | |||
Array element | Excel Programming |