Hi,
I have below formula that gives me ranges between first cell with numeric value and last cell with numeric value. Range changes based on slier selection. When I enter below formula "Select data - Add- Series Values" to a chart I get "There is an error in formula you entered error message. Is there a work around this where Excel Graph reads blow formula as range? Thanks
="Sheet1!"&"H"&MATCH(INDEX(G2:G12,MATCH(TRUE,INDEX(ISNUMBER(G2:G12),0),0)),G:G,0)&":"&"H"&MATCH(LOOKUP(2,1/(G:G<>""),G:G),G3:G12,0)
returns Sheet1!H2:H9
I have below formula that gives me ranges between first cell with numeric value and last cell with numeric value. Range changes based on slier selection. When I enter below formula "Select data - Add- Series Values" to a chart I get "There is an error in formula you entered error message. Is there a work around this where Excel Graph reads blow formula as range? Thanks
="Sheet1!"&"H"&MATCH(INDEX(G2:G12,MATCH(TRUE,INDEX(ISNUMBER(G2:G12),0),0)),G:G,0)&":"&"H"&MATCH(LOOKUP(2,1/(G:G<>""),G:G),G3:G12,0)
returns Sheet1!H2:H9