Doing a simple Trend as explained here
TREND function - Excel - Office.com
I was able to do this using 3 month trending and using Month Numbers.
Now I have expanded my sheet for 17 weeks, using WeekNumbers and everything is the same just more columns
Got any ideas? Yes I did Shift CTRL Enter for the array but it worked without doing that as well when I was trending 3 months.
TREND function - Excel - Office.com
I was able to do this using 3 month trending and using Month Numbers.
Now I have expanded my sheet for 17 weeks, using WeekNumbers and everything is the same just more columns
Got any ideas? Yes I did Shift CTRL Enter for the array but it worked without doing that as well when I was trending 3 months.