market

Hi I'm trying to forecast my unit sales for the following year. I have last years data but I'm at a loss as to where i begin. My data is below along with what i expect the market changes to be. <colgroup><col><col span="12"></colgroup><tbody> Monthly Data Jan Feb Mar Apr May Jun...

Hi. = Workday(A1,1,[holidays]) For the "holidays" I have no problem with my list: (1/1/19, 1/21/19, 2/18/19, etc.). However, I am making a stock market calendar with different time increments. Sometimes the market closes an hour earlier to observe the upcoming holiday. Thus instead of...

Hello Im new to excel and wondering would it be possible to change the hour formula to hour and minute? example first column which has hour {0;7;22} can it be changed to {0:30;7:30:22:30} as in the energy market it always starts at 7:30 not 7 for example, LOOKUP(HOUR(B2),{0;7;22},{"Off...

Hi, I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example: In Category 1, Customer A had growth of 2% in the market but our business...

Hi All, I am trying to compare two tables of having varied rows and columns. I want to see if values in table 1 matches with data in table 2. I am using index and match formula. I am checking each cell in table 1 with table 2 data set. However I am getting 'no match' everytime. Can anyone...

I have some pretty cool code set up that will automatically run when a workbook opens depending on the file name. I want to be able to compare each word of each name in two different workbooks and if any of the words in the name match, do something. EX1: Workbook one is named, "FL HOME MARKET...

Can anybody tell me how to copy cell data at specified date and time ? I am having auto updating every 15 min sheet of stock market price. I want to save data every 15 min to a predefined cell.for one day. Thanks in advance

The value in column F is 1000. The value in column D is 21.14. Each time I increase the value in F by 1000 the value in D should also double, E.G. – F = 2000 then D = 42.28 and so on. Is there a formula I can place in column G that will calculate the base amount in column D each time I change or...

Hello everyone, Been some time I've posted here, but this has been bugging me for few days now and i cant wrap my head around: Problem: i have employees salary data and i have market max/ave/min salary data. 1. make stacked floating chart for market data and put scatter points per categories...

Hi, I'm having trouble with this problem Construct a forecasting worksheet to calculate: 1. the number of new clients each month, and 2. the total client base (cumulative number of clients signed up) each month. In your model, make projections for 60 months (Periods) for the two scenarios...

Hello I have a work book with two tabs. 1. Contractual Rent Steps - This shows the annual cost per square foot. 2. Market Rent Steps - This will use the annual market cost per square foot with a 3% increase when the tenants Contractual annual rent step increases. What I am trying to do is...

Hi all, I'm hoping someone can help with my problem. I need a formula which can concatenate the values in a row along with its corresponding column header and sub header descriptions, I assume it might some combination of INDIRECT with Match and Concatenate but am struggling to thing of how it...

The problem with the missing formula in a cell has been haunting me for the last 2 months. I have heard of all of the possible causes but none of the solutions have helped me. I wrote a letter to Microsoft asking that some resources be put on the issue. It would seem that you could have the...

Good day. Need to know price of apple in 120203... what excel formula shall i use??? i have large database with different product code as well as market code!!! <tbody> Product Code Product name price market code 001 apple 2.00 120203 001 apple 2.00 120203 001 apple 3.00 120203 001...

Hello guys, Need your help as i need to know listed (repeated price) price for apple sold in 120203 :warning: which excel formula shall i use? i have large database with different product and market code... <tbody> Product Code Product name price market code 001 apple 2.00 120203 001...

Hi I have a problem that I'm not able to overcome. I have the data as shown below (dataset much larger, but follows the logic below). - Cells A1:C1 are merged, so are D1:F1 and so on - I want to show a graph with Months on the X-axis, and Market Share on the Y-axis, and then different lines...

Hi guys. My first post! I am trying to model multiple players entering a market with pre-defined probability. The portion that I cannot solve is starting a cash flow when the players enters the market and ends when the revenue reaches a certain level within a five year period. For example, the...

Hi, I have a large data set and I am looking for a formula that can help me select the top 5 items based on 4 criteria that may change. For example, my data set has the below headers and I want to return the name of the Market for the top 5 scores. I'd also like to be able to change the...

I have a typical Fact Table and a typical Customer Table. My Measures include Market Share within Country and Market Share Globally... for example; the country market share is calculated as follows; Total Revenue Last 12...

Hello, I was wondering if it is possible to have a column in calculate based on the fields that are included. For example, if only market is available, I want the % of per capita spending to be divided by the total across all markets, but if I include market and product, have the % spending to...