Nov 22 2021 05:08 AM
Hi
I have a table of 252 unique combinations these have been times by 53 to get 13,356 rows.
In Column A i am trying to add the week no for each unique combination so for example the first 252 unique combinations in row C, D and E will have no 1 in column A then the next 252 rows will have no 2 in column A and so on all the way up to 53. I have attached the Workbook
Is there a formula that can do this for me ?
Nov 22 2021 05:21 AM
@excel_learner Similar to this, I guess:
https://techcommunity.microsoft.com/t5/excel/copying-down-rows/m-p/2959533
Nov 22 2021 05:45 AM
The issue I'm having with how the budget forecast and actuals are laid out in power query I want to have it laid it out as " budge, forecast, Actuals"
like this below
but when I sort the customer column (week no) it becomes like this the BFA column is not in the correct order. is there a way to get in the correct order of Budget then forecast then actuals whilst having the week no sorted ascending.
Nov 22 2021 06:09 AM
Solution@excel_learner Include the Index column in your sort. First by Week no then by Index. But, perhaps, difficult to judge from screenshots alone.
Nov 22 2021 06:09 AM
Solution@excel_learner Include the Index column in your sort. First by Week no then by Index. But, perhaps, difficult to judge from screenshots alone.