balling_threes
Board Regular
- Joined
- Jun 30, 2009
- Messages
- 85
Hey,
I'm trying to figure out how to name a range based on values within the sheet.
For example:
I have a table that looks like this:
<table style="border: 1pt solid rgb(163, 163, 163); border-collapse: collapse; direction: ltr;" valign="top" border="1" cellpadding="0" cellspacing="0"><tbody><tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;">1
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;">2
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;">3
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;">4
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;">5
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;">6
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;">7
</td></tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">A
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;" align="center">x
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;" align="center">5
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;" align="center">3
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;" align="center">34
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;" align="center">23
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;" align="center">34
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;" align="center">x
</td></tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">B
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;" align="center">x</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;" align="center">500
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;" align="center">222
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;" align="center">345
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;" align="center">1234
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;" align="center">1234
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;" align="center">x
</td></tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">C
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;" align="center">x</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;" align="center">$96.44
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;" align="center">$99.51
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;" align="center">$102.57
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;" align="center">$111.76 </td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;" align="center">$120.95
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;" align="center">x
</td></tr></tr></tbody></table>
I want to create range from A2:C6. The range will always be 3 rows high. But the number of columns in the range will be different everytime.
So I want the range to start one cell to the right the first X (column 2 in this case), and end one cell to the left of the next column with an "X" in it (column 6 in this case). And I want to name the range "start".
I've been looking at beginning name ranging, but could not figure it out. Does any one have any ideas or suggestions on how I could approach this?
Thanks so much, Guillaume.
I'm trying to figure out how to name a range based on values within the sheet.
For example:
I have a table that looks like this:
<table style="border: 1pt solid rgb(163, 163, 163); border-collapse: collapse; direction: ltr;" valign="top" border="1" cellpadding="0" cellspacing="0"><tbody><tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;">1
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;">2
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;">3
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;">4
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;">5
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;">6
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;">7
</td></tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">A
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;" align="center">x
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;" align="center">5
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;" align="center">3
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;" align="center">34
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;" align="center">23
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;" align="center">34
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;" align="center">x
</td></tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">B
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;" align="center">x</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;" align="center">500
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;" align="center">222
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;" align="center">345
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;" align="center">1234
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;" align="center">1234
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;" align="center">x
</td></tr><tr><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.127in; vertical-align: top;">C
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 1.12in; vertical-align: top;" align="center">x</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.667in; vertical-align: top;" align="center">$96.44
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.672in; vertical-align: top;" align="center">$99.51
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.715in; vertical-align: top;" align="center">$102.57
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.714in; vertical-align: top;" align="center">$111.76 </td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.75in; vertical-align: top;" align="center">$120.95
</td><td style="border: 1pt solid rgb(163, 163, 163); padding: 4pt; width: 0.779in; vertical-align: top;" align="center">x
</td></tr></tr></tbody></table>
I want to create range from A2:C6. The range will always be 3 rows high. But the number of columns in the range will be different everytime.
So I want the range to start one cell to the right the first X (column 2 in this case), and end one cell to the left of the next column with an "X" in it (column 6 in this case). And I want to name the range "start".
I've been looking at beginning name ranging, but could not figure it out. Does any one have any ideas or suggestions on how I could approach this?
Thanks so much, Guillaume.