B
bgetson
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.
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.