# trend formula

1. ### YTD Dynamic 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...
2. ### Data trend without a graph

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...
3. ### TREND or FORECAST function

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...
4. ### Creating Growth Trend from 2 Sets of Values

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 -...
5. ### Function for Trends/Streaks?

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?
6. ### Trend formula ignore Div/0 error

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back