Agent86
Board Regular
- Joined
- Feb 28, 2003
- Messages
- 229
I'm using the formulas rather than code to accomplish what I'm trying to do. Basically, I'm picking up data from another sheet and counting the number of times that a particular name shows up within a specified date range. Furthermore, it counts the number of times that the above occurs, but seperates the count depending on a third variable - that being whether the names that fall within the date range have a designation of either "AR1" or "AR2".
My problem is that even though the formulas work, they cause the sheet to calculate very slowly. This further concerns me because the final version will need to have about 250 rows on Sheet1, and 1000's of rows on Sheet2.
Is there code that could be written that would be more efficient, and yet achieve the same outcome?
Below are conceptual drafts of sheets 1 and 2 ... thank you for any direction you can provide me.
My problem is that even though the formulas work, they cause the sheet to calculate very slowly. This further concerns me because the final version will need to have about 250 rows on Sheet1, and 1000's of rows on Sheet2.
Is there code that could be written that would be more efficient, and yet achieve the same outcome?
Below are conceptual drafts of sheets 1 and 2 ... thank you for any direction you can provide me.
km_biweekly_analysis_12-05-2003-test3.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | |||||||||
3 | From: | 12/1/2003 | |||||||
4 | To: | 12/15/2003 | |||||||
5 | Name | Region1 | |||||||
6 | AR1 | AR2 | TOT | ||||||
7 | Bob | 1 | 1 | 2 | |||||
8 | Bill | 0 | 1 | 1 | |||||
9 | Mary | 1 | 0 | 1 | |||||
10 | Peter | 0 | 1 | 1 | |||||
11 | Ron | 1 | 1 | 2 | |||||
12 | |||||||||
13 | |||||||||
Sheet1 |
km_biweekly_analysis_12-05-2003-test3.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Name | Item | WeekEndingDate | |||
2 | Bob | AR1 | 12/1/2003 | |||
3 | Bill | AR2 | 12/2/2003 | |||
4 | Mary | AR1 | 12/3/2003 | |||
5 | Peter | AR2 | 12/4/2003 | |||
6 | Ron | AR1 | 12/5/2003 | |||
7 | Bob | AR2 | 12/6/2003 | |||
8 | Bill | AR1 | 12/20/2003 | |||
9 | Mary | AR2 | 12/23/2003 | |||
10 | Peter | AR2 | 12/24/2003 | |||
11 | Ron | AR1 | 12/25/2003 | |||
12 | Bob | AR2 | 11/28/2003 | |||
13 | Bill | AR2 | 11/28/2003 | |||
14 | Mary | AR1 | 11/28/2003 | |||
15 | Peter | AR2 | 11/28/2003 | |||
16 | Ron | AR2 | 12/15/2003 | |||
17 | ||||||
Sheet2 |