Hi,
I am trying to develop a dynamic range for a scatter graph from an index that selects a row of data from the raw data below for comparison. My formula at the moment looks like what you can see below; however I can't quite get it to work. Is there something obvious I am missing?
=SERIES('Total Report'!$C$6,'Total Report'!=OFFSET($D$5,0,0,MAX(IF(ISNUMBER(5:5),ROW(5:5)-3,0)),1)),'Total Report'!=OFFSET($D$6,0,0,MAX(IF(ISNUMBER(5:5)-3,0)),1)),1)
Regards,
Hereward
I am trying to develop a dynamic range for a scatter graph from an index that selects a row of data from the raw data below for comparison. My formula at the moment looks like what you can see below; however I can't quite get it to work. Is there something obvious I am missing?
=SERIES('Total Report'!$C$6,'Total Report'!=OFFSET($D$5,0,0,MAX(IF(ISNUMBER(5:5),ROW(5:5)-3,0)),1)),'Total Report'!=OFFSET($D$6,0,0,MAX(IF(ISNUMBER(5:5)-3,0)),1)),1)
Regards,
Hereward