how to specify a range that is variable.
I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and end columns, how do I specify the ranges in various formulas that would use the start and end column variables but different rows? Do I have to use VBA which I am not very good at? Thanks for any help. -- Mal |
how to specify a range that is variable.
You can create a range just like Frankenstein, splice together pieces. Say
A1 thru A4 contain: C F 3 5 In A5 enter: =SUM(INDIRECT(A1&A3&":"&A2&A4)) this is the same as entering: =SUM(C3:F5) -- Gary''s Student - gsnu200777 "Mal" wrote: I have a control variable sheet that has the "start" and "end" column numbers. For a number of different data ranges that us the same start and end columns, how do I specify the ranges in various formulas that would use the start and end column variables but different rows? Do I have to use VBA which I am not very good at? Thanks for any help. -- Mal |
how to specify a range that is variable.
This may be of interest to you:
http://www.contextures.com/xlNames01.html Regards, Ryan--- -- RyGuy "Gary''s Student" wrote: You can create a range just like Frankenstein, splice together pieces. Say A1 thru A4 contain: C F 3 5 In A5 enter: =SUM(INDIRECT(A1&A3&":"&A2&A4)) this is the same as entering: =SUM(C3:F5) -- Gary''s Student - gsnu200777 "Mal" wrote: I have a control variable sheet that has the "start" and "end" column numbers. For a number of different data ranges that us the same start and end columns, how do I specify the ranges in various formulas that would use the start and end column variables but different rows? Do I have to use VBA which I am not very good at? Thanks for any help. -- Mal |
how to specify a range that is variable.
Whoops, hit the 'Post' button too fast; ment to give you this too:
http://www.ozgrid.com/Excel/DynamicRanges.htm Regards, Ryan-- -- RyGuy "ryguy7272" wrote: This may be of interest to you: http://www.contextures.com/xlNames01.html Regards, Ryan--- -- RyGuy "Gary''s Student" wrote: You can create a range just like Frankenstein, splice together pieces. Say A1 thru A4 contain: C F 3 5 In A5 enter: =SUM(INDIRECT(A1&A3&":"&A2&A4)) this is the same as entering: =SUM(C3:F5) -- Gary''s Student - gsnu200777 "Mal" wrote: I have a control variable sheet that has the "start" and "end" column numbers. For a number of different data ranges that us the same start and end columns, how do I specify the ranges in various formulas that would use the start and end column variables but different rows? Do I have to use VBA which I am not very good at? Thanks for any help. -- Mal |
how to specify a range that is variable.
Thanks Ryan....Named Ranges are under-utilized and should be given more
publicity. -- Gary''s Student - gsnu200778 "ryguy7272" wrote: Whoops, hit the 'Post' button too fast; ment to give you this too: http://www.ozgrid.com/Excel/DynamicRanges.htm Regards, Ryan-- -- RyGuy "ryguy7272" wrote: This may be of interest to you: http://www.contextures.com/xlNames01.html Regards, Ryan--- -- RyGuy "Gary''s Student" wrote: You can create a range just like Frankenstein, splice together pieces. Say A1 thru A4 contain: C F 3 5 In A5 enter: =SUM(INDIRECT(A1&A3&":"&A2&A4)) this is the same as entering: =SUM(C3:F5) -- Gary''s Student - gsnu200777 "Mal" wrote: I have a control variable sheet that has the "start" and "end" column numbers. For a number of different data ranges that us the same start and end columns, how do I specify the ranges in various formulas that would use the start and end column variables but different rows? Do I have to use VBA which I am not very good at? Thanks for any help. -- Mal |
All times are GMT +1. The time now is 08:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com