Forum Discussion
Solved
Formula for copying down formula in specific order
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 uniq...
excel_learner Include the Index column in your sort. First by Week no then by Index. But, perhaps, difficult to judge from screenshots alone.
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.
excel_learner Include the Index column in your sort. First by Week no then by Index. But, perhaps, difficult to judge from screenshots alone.