trend formula

Hi All, could someone please help me figure out how to make a dynamic trend formula in a following way: I calculated YTD trend as but would like the Trend formula to automatically take into account the following month once I update the source table with September Actuals so that the trend for...

I am attempting to trend data without using a graph. The data would look something like this: Week Revenue 1 $90,934.15 2 $143,314.75 3 $134,522.00 4 $202,343.00 5 $177,218.00 6 $132,985.75 7 $113,291.00 8 $62,821.00 9 $151,983.00 10 $161,214.80 11 $142,278.45 12...

I'm trying to trend out some numbers. I have two sets of numbers: The first we can call a "local" projection and the second we can call a "national" projection. For the national projection I know all 3 numbers: Low, Medium, High For the local projection I know only 1 number: Low I would...

Hi, I'm creating a growth trend with a group of data and I'm stuck trying to find a way to automate this with a formula without manually using trial and error to arrive at the values. The graph representing the growth trend charts number of man-hours for a department by week from January -...

If I wanted to count cells that occurred in a trend, what function could I use? For example, if I am keeping track of wins and losses, and my cells go W, L, W, W, W How can I count to show a 3 win streak that would go to 0 if an L were to occur?

i have a couple columns and want to use the Trend Function in excel but that data contains the error #Div/0. is there an easy way to get around this error. =TREND($A$1:$A$10,$B$1:$C$10,B1:C1,TRUE) in column B there is an error div/0 any help is greatly appreciated. Thank you