trending

I am trying to add trend arrows to my data based on the previous month. Please see the examples table below. Let's say we're looking at the data of orange crates sold each month for the last six months. January- 16, February- 6, March- 7, April- 4. May- 18 and June- 47. How would I get arrows to...

I would like to create a Power BI Report to help with forecasting. Part of what I would like to see is the following based on an input of a specific date any user could enter. Not sure if that's possible in Power BI: - Previous Year (Day) - Not the Date but the Day of the Week for the previous...

Please bear with this explanation as it may be lengthy but I want to be as clear as possible with my problem.. I am trying to detect with a formula the trend over the past 6 months of my data. I do not simply want to see if the data has increased from one month to the next month; rather I want...

Hey guys. I have a worksheet given to me by corporate where they expect us to fill numerous rows in a column each day. Once they are entered we are to compare the last two columns and for each row show whether we are trending up or down in a separate column. Let's say I just filled Column AN...

Hi Everyone, I've included a cleaned version of the workbook I will be using (the native file includes commercially sensitive information) that is identical in layout and structure to the native workbook. I'm trying to set up a workbook that copies information from ['Raw_Data' columns B, D...

I have a somewhat complicated problem that I was hoping some of you may have some ideas for, both in approach and execution in Excel. SITUATION: We have many accounts (70+) each of varying sizes and ticket volumes. Some accounts may have thousands of tickets per week, others may have 1 or less...

Can't figure out how to chart this. Here are a few dates. Followed by an Investment Account. Then the spot price of two metals. The Account represents the total value of over a dozen mining stocks. Some stocks are pure play for one metal. Some have a 30% 70% mix of both metals. We are trying...

First, this is long, but I want to be as descriptive as possible. This modeling is explores using basic attendance data to enrich decisions (which folks to call to keep attendance up). THE PROBLEM/QUESTION: I need help in #excel.I'm using MS Office 2013 and want to model attendance records...

Hi Everyone, I am working on a pharmaceutical inline forecasting project and need some readily available trending tool which can trend on monthly level considering different trends (best fit should be selected automatically) and historical seasonality. I have created one and want to share with...