Can INDEX be used in conjunction with OFFSET?

K

KG

I often use INDEX and combo boxes to create interactive charts. Can INDEX and
OFFSET used together so that INDEX only reads every other row in a column of
data? Or is there a better way to accomplish the same result?
 
F

Frank Kabel

Hi
I would first create a helper column with only your relevant data (e.g.
using OFFSET) and then chart this helper column (you can also hide this
column)
 
Top