RandyTampa
New Member
- Joined
- Dec 18, 2003
- Messages
- 45
Sorry if this is vague but this is essentially my problem:
I have several sets of zip codes across a state. I want to take groups of zip codes at a time and apply formulas to all the zip codes in a group at a time. The issue is that not all groups have the same number of zip codes.
For example, group A has 100 zip codes and group B has 74 zip codes.
Formulas might involve summing a column C so that in that column
=sum(D1:D$101) for Group A but for goup B that formula would be sum(D1:D$75).
Since there are dozens of formulas that are dependent upon a given number of rows across many different tabs, it's not feasible to make individual formula changes for each group.
Any advice?
thanks
I have several sets of zip codes across a state. I want to take groups of zip codes at a time and apply formulas to all the zip codes in a group at a time. The issue is that not all groups have the same number of zip codes.
For example, group A has 100 zip codes and group B has 74 zip codes.
Formulas might involve summing a column C so that in that column
=sum(D1:D$101) for Group A but for goup B that formula would be sum(D1:D$75).
Since there are dozens of formulas that are dependent upon a given number of rows across many different tabs, it's not feasible to make individual formula changes for each group.
Any advice?
thanks