B
bgetson
I posted this earlier in the programming group, but I think that this
is the right place.
I am attempting to create a named range for a graph to display data
from the end of each month. Ideally, the data for the range would come
from the following set:
A Jan Feb Mar Apr
B g2 g8 g12 #N/A
where each cell in row B contains a cell reference for the date of the
last workday of a month. For months that have not occured yet, the
formula I created returns the #N/A error. My problem is creating the
named range that uses the INDIRECT() function to read in each cell
reference that exists.
The data needs to remain a cell reference (instead of the value it is
referring to) so that I can later use an OFFSET() function on the named
range to grab the performance values for each month.
Any comments or suggestions would be greatly appreciated.
- BGetson
is the right place.
I am attempting to create a named range for a graph to display data
from the end of each month. Ideally, the data for the range would come
from the following set:
A Jan Feb Mar Apr
B g2 g8 g12 #N/A
where each cell in row B contains a cell reference for the date of the
last workday of a month. For months that have not occured yet, the
formula I created returns the #N/A error. My problem is creating the
named range that uses the INDIRECT() function to read in each cell
reference that exists.
The data needs to remain a cell reference (instead of the value it is
referring to) so that I can later use an OFFSET() function on the named
range to grab the performance values for each month.
Any comments or suggestions would be greatly appreciated.
- BGetson