Hi
I have a spreadsheet which works but it is way too slow - what I'm trying to do is to aggregate daily time sheets by person and job, determining the unique combinations of people and jobs then adding the total values for those combinations by week number.
I've used concatenate to determine the unique combinations and then nested if statements in an array sum formula to get the answer but each time it calculates it takes up to 5 minutes.
I have around 6,000 initial daily records but have reduced that in a workbook which it apears I can't load here presently.
I have a workbook with 3 sheets, the first with name, job and values, the second with the same amount of rows concatenating the name and the job and providing numbering of unique combinations, and the third worksheet references the numbering and carries out the conditional array sum on the original data.
I'm wondering if there is a more classical or VBA approach to get the DataTransfer worksheet result?
Many thanks in advance.
John
I have a spreadsheet which works but it is way too slow - what I'm trying to do is to aggregate daily time sheets by person and job, determining the unique combinations of people and jobs then adding the total values for those combinations by week number.
I've used concatenate to determine the unique combinations and then nested if statements in an array sum formula to get the answer but each time it calculates it takes up to 5 minutes.
I have around 6,000 initial daily records but have reduced that in a workbook which it apears I can't load here presently.
I have a workbook with 3 sheets, the first with name, job and values, the second with the same amount of rows concatenating the name and the job and providing numbering of unique combinations, and the third worksheet references the numbering and carries out the conditional array sum on the original data.
I'm wondering if there is a more classical or VBA approach to get the DataTransfer worksheet result?
Many thanks in advance.
John
