# Get instant live Excel expert help with COLUMNS Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to be able to drag a number down a column and have it increase in value by 1 each time. How do I do this?
Solved by D. D. in 21 mins
How do I change a column of (-) Negative values to Positive? (+) I have a list of business expenses on a spreadsheet.
Solved by X. W. in 25 mins
I NEED TO KNOW WHAT FORMULA TO USE FOR THIS PROBLEM. i HAVE A TABLE OF DATA (2ND PAGE OF A SINGLE EXCEL DOCUMENT) WHICH i WANT TO REFERENCE AND PULL INFO FROM INTO THE 1ST PAGE BASED ON A COLUMN HEADING
Solved by S. W. in 15 mins
Please review the enclosed EXCEL file: The formula I have entered{ VLOOKUP(B2,Candidates!\$A\$2:\$B\$606,2,FALSE)} on the column I of the Sheet (SUBJECT1) returns AN ERROR MESSAGE (#N/A). How do I solve the problem???
Solved by V. H. in 30 mins
how can i get value of from sheet2 (H column) thats equal to sheet1 (A column)
Solved by T. S. in 29 mins
In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays \$950.00.
Solved by E. Y. in 27 mins
I have a large set of data (40k entries). The columns include Account ID, Associate, Order Description, Date and Time. There are several Account IDs. Each is linked to one Associate. However, the Associates have various Account IDs to service. I need to generate a report/export data/filter out all the entries that have given criteria. The tricky thing is my criteria list is also rather long. I have about 100 total possible conditions, so I need all entries that have a given Order Description AND a specific order date. There are 100 totals sets of criteria. What would you advise would help me do this? How do I filter with many conditional filters? It isn't as simple as clicking the filters I want from each column because 1. the column value must also go with another column value and 2. There are so many possibilities. Ie. I don't want to generate a list of all orders with Order Description - blueberries, oranges, apples, etc. I want to generate a list of all orders with Order Description blueberries on March 1, 2016, oranges on April 3, 2017, oranges January 5,2017, apples March 10,2017.
Solved by F. F. in 19 mins
I have a list of names in Column A and a list of telephone numbers in Column B. The are both on the same spreadsheet "NAMES & NUMBERS". On a different spreadsheet, within the same workbook, I would like to have a drop down where I can choose the name in A1 and it will automatically populate A2 with the corresponding telephone number for that particular person. I have searched for 2 hours on the web trying to find out how to do this. Please help!
Solved by D. J. in 28 mins
This Feature Billing spreadsheet is something we use at our company for quoting our clients. We build custom software, and clients typically have very similar feature requests. The New Quote Tab is where a sales person would work. As they talk to the client, the put an "x" in the Selection column (Column H). This generates a price. With that said, each of those selections maps to another set of requirements that we want to communicate with our developers. The "Base-Components-With-Subtasks" tab represents the start of listing out the subtasks. If the sales person puts in X in row 2 of the New Quote tab, our developers need to know to build rows 2-5 of on the "Base-Components-With-Subtasks" tab. The output of this is supposed to be on the "Populated Story Map Tab." Currently I have it so it lists out all the items (and only those items) that are being selected from the New Quote tab, which is a great first step. But I also need it to list out all of the sub-tasks (in individual rows) that the selection maps to on the Base-Components-With-Subtasks. For example, on the Populated Story Map tab, there should be 4 rows for story 1.
Solved by V. H. in 27 mins
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.
Solved by A. J. in 18 mins