Dynamic Range for chart

    Hi All


    Any thoughts for a dynamic range that will use data from sheet1 but only from every 6th cell in Row E starting from E11.


    i.e. E11, K11, Q11 etc


    Thanks

    Hi,


    If you need to build your range ... you can use :


    Code
    =Offset($E$5,(row(a1) * 6) -1,0)


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hope the Offset function will work for you ...


    Should you face difficulties ... do not hesitate to attach your file ...


    In our Forum ... this feature is a HUGE advantage ... compared to other forums ...!!! :wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login