Get instant live Excel expert help to learn how to use Large function?

I have a large spreadsheet detailing tasks that need to be completed by different staff people, i.e., Server1, Server2, Bar1, etc. It also shows which day the task needs to be performed. The "All Items" tab details all the tasks. I have a 2nd tab titled "Tasks by Role" where I want to pull data from the first tab to show all the tasks on a day for a specific role, i.e., all tasks assigned to "Server1" on "Wednesday". I've uploaded the file for your help. Thank you!

In Excel, what formula can I use to assign and calculate total numerical values for three columns of words? For example, Column A is "yes" or "no". Column B is "small", "medium", or "large". Column C is "yes" or "no". For Column A, yes contains a value of 5 while "no" contains no value. For Column B, small contains a value of 20, medium is 40, and large is 50. For Column C, "yes" is 10 and no is 0. See attached picture for an example. Column D is where the result should calculate, combining the three columns numerical values. Thank you for your help!

I am trying to make a graph with a selected data set. On my x axis i have a large value range...however this value range will change with depending on the person using it. I want to build it to where they dont have to select the range for the variable...but i dont want the legend at the bottom to show all the unused variables

I'm receiving an error with my HLOOKUP formula in column AO of the Base_$ Pivot. The file is too large to pull onto Google Sheets and will need to be downloaded directly from the chat

I use a large spreadsheet with external links and formulas. I calculate manually (F9). When I open the spreadsheet it works well. The longer I have it open the slower it becomes until I have to close it and reopen, at which point it works well again for awhile. How can I speed up my calculations? is there a cache I can dump or something?

If column F = Small column J will be date from column H minus 60 days If Column F = Medium Column J will be date from column H minus 120 days If Column F = Large column J will be date from Column H minus 180 days

I have a large .xlsx file with text data that I would like to be able to search with various terms. The find function works for 1 word or 2 words beside each other but I need a way to search for 2 or 3 different words throughout a cell that may not be beside each other, throughout the sheet. Thank you.

I need to simulate a large set of random numbers between 0 and 100 which have the following probability of occurring within the following ranges: Capacity Probability 0 0.15 30 to < 50 0.15 50 to < 70 0.30 70 to < 85 0.25 85 to < 100 0.15

Hi, I need help with the 'MATCH FUNCTION' I have a very large data set and trying to extract data from there. For ex: if user enters 'W14x38' and excel should get all stuff related to section (area, length, width, etc)

The accompanying dataset contains six years of quarterly sales from your store. You would like to forecast future sales as way to inform you as you make staffing and budgeting plans. Please answer all of the following questions. The dataset can be found here. For numerical questions, answer with 4 digits to the right of the decimal. Statistically test at the alpha=0.05 statistical significance level whether or not there exists a linear trend in the time series data. What is the p-value of your statistical test? Based on your answer to the question above, can you conclude that a linear trend exists in this time series data (Y or N)? ===== Regardless of you answer above, create a multiple linear regression model that captures both linear trend and additive seasonality. You should use Q4 as your base season and fit the model with all 24 data points. All of the independent variables are statistically significant at the alpha=0.01 level (Y or N). Which quarter (1, 2, 3, or 4) has the largest sales on average? Which quarter (1, 2, 3, or 4) has the smallest sales on average? What is the value of the Adjusted R-squared? Using this multiple linear regression model, what is the value of the MAPE? (Please report it as a percentage with 4 digits to the right of the decimal and no percentage sign.) Using this multiple linear regression model, forecast each quarter for the next year (2016). What is the forecast for Q3? Carefully explain the how to interpret the value of the estimated coefficient on the time period index. Carefully explain the how to interpret the value of the estimated coefficient on the variable representing quarter one. ===== Using the same dataset as before, you now would like to add an exogenous variable as a possible explanatory variable to the model. This variable is in the column labeled ‘Ads – Lag 1’. This variable represents the number of advertising campaigns ran the previous quarter. (The thought is that the ads run last quarter affect the current quarter’s sales.) Calculate the correlation coefficient between the variables ‘Ads – Lag 1’ and ‘Sales’. What is its value? Continuing with this thought, now create a multiple linear regression model that captures both linear trend and additive seasonality. You should use Q4 as your base season and fit the model with all 24 data points. Additionally, add the variable ‘Ads – Lag 1` as an independent variable. Is the variable ‘Ads – Lag 1` statistically significant at the alpha=0.05 level (Y or N)? What is the value of the Adjusted R-squared value? 0.4699 Using this multiple linear regression model that captures trend and additive seasonality and the additional independent variable for advertising, what is the value of the MAPE? (Please report it as a percentage with 4 digits to the right of the decimal and no percentage sign.) Using only the data that you have been given, can you make forecasts for the year 2016 using this model (Y or N)? If your answer was “Y” above, then what is the forecast for Q1 of 2016. If it was “N”, explain why not.