Share via

looking to offset my data inside indirect function to avoid including row 1-3

Anonymous
2023-02-22T18:42:17+00:00

=INDIRECT("Sheet1!$D"&Station_Lookup&":D"&Station_Lookup+Stations_Being_Shown) looking to somehow offset this formula so it starts on row d4 and then changes with my other formula to add or remove rows or shift. currently everything is working just the header of the chart is included in my graph. any help would be appreciated. Thanks

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-23T05:20:42+00:00

    Dear Emmett Shuttleworth (TEMA)

    Good day! Thank you for posting in Microsoft Community.

    Based on your description, we do understand you want to use the above formula to offset your data so that it can starts on row d4 and avoid including row 1-3.

    In this scenario, to better understand your situation, can you share a copy of the data or some screenshots of your data to us so that we can have a test and understand your situation better?

    You can upload your file to OneDrive then share the link in here.

    If the scenario above is not consistent with yours, you can also post back and point that. Looking forward to your reply, please notice the above information is vital for us to further assist you, any updates please feel free to post back.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Stacey | Microsoft Community Moderator

    Was this answer helpful?

    0 comments