|
How to create a range address with ADDRESS function?
I can use this formula, =INDIRECT(ADDRESS(10,2)), but I haven't figured out
how to specify a range as in =INDIRECT(ADDRESS(10,2) & ":" & ADDRESS(30,6)). I can put the range address into a cell and then reference the cell with INDIRECT, but it would be nice to imbed the range address calculation inside the INDIRECT function and save the step. -- Pictou |
How to create a range address with ADDRESS function?
Your initial try is actually correct! It's just a matter of using it the
right way. For example: =SUM(INDIRECT(ADDRESS(1,2) & ":" & ADDRESS(10,10))) will work just fine -- Gary''s Student - gsnu200820 "Steve McLeod" wrote: I can use this formula, =INDIRECT(ADDRESS(10,2)), but I haven't figured out how to specify a range as in =INDIRECT(ADDRESS(10,2) & ":" & ADDRESS(30,6)). I can put the range address into a cell and then reference the cell with INDIRECT, but it would be nice to imbed the range address calculation inside the INDIRECT function and save the step. -- Pictou |
| All times are GMT +1. The time now is 01:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com