Forum Discussion
Solved
Build a Range from the values of two cells
Hello, everyone. First post on this forum. I'm looking to use a range in an XIRR formula, but this range is not static, it might change. I would like to know how to build a range/array by doing t...
- The INDIRECT function is what you are need here. Note that this function always recalculates meaning of calculation intensive cells depend on cells containing INDIRECT, they will recalc regardless of what was changed in your model.
The INDIRECT function is what you are need here. Note that this function always recalculates meaning of calculation intensive cells depend on cells containing INDIRECT, they will recalc regardless of what was changed in your model.
I tried that I believe, but I only seem to get the first and last values in the range. See pictures.
Edited:
Actually I should be doing Indirect(B1):Indirect(B2). That gives me the correct array. Thank you.
I am not sure why you would do it that way. I just learnt some from this community. You may want to do it like
=OFFSET($A$1,0,0,COUNT($A$1:$A$1000),1)
- Or: =INDIRECT(B1&":"&B2)
