Hello All, I am using studiox and have a multipage excel workbook (one per market/state) each sheet is the same but every week a new column is added. The final column needs to calculate the baseline (first column of data for each row). The initial baseline column was J…BUT, as new rows were added alot of markets did not have any data for that first week…column J. The data starts at J3 and ends at row 212. So for example, the first category rows for week 1, the baseline is column J. But as the weeks progress and new rows are added the baseline becomes column N for some rows and column R for others…it cascades down.
I hope this makes sense. Any help would be greatly appreciated
It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.
First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.
You can check out some of our resources directly, see below:
Always search first. It is the best way to quickly find your answer. Check out the icon for that.
Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.
Topic that contains most common solutions with example project files can be found here.
Read our official documentation where you can find a lot of information and instructions about each of our products:
Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.
Thank you for helping us build our UiPath Community!
