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 was jut receiving help from a spreadsheet expert. He/She was able to create the right formula in cell F2, but now I'd like to figure out how to easily take that formula across column 2 without having to type in date and time criteria for each cell.
Solved by I. W. in 24 mins
I need to write a nested if statement. I have to identify those with a value greater than 0 in column A but have a zero value in columns C & D to return a value of "Lost" if the criteria matches and Active for those that dont match.
Solved by M. D. in 22 mins
Pls see attached sheet. I need a formula in the “TOTAL YEARS (REHIRES ONLY)” column, which will add I2:I3. I'm having a hard time because I2:I3 has a DATEDIF excel formula already in it
Solved by E. J. in 19 mins
use of solver To best match the group with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable). Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each group receives no worse than their 6th best choice. Two groups have specific needs and have requested a particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs to use the Refactor Room. To complete this task, you should use Solver. The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not been assigned. Only one meeting room can be assigned to each group and each group can only reserve one room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells will contain the value 0. The values in the preference value column should be no greater than 6 indicating each group will receive no worse than their 6th best choice. The preference total cell is the sum of these scores.
Solved by S. C. in 27 mins
i would like a macro that goes through all sheets except 'main'. in those sheets, loop through column D to find any blank cells and fill them with "0" (highlighted in yellow). Then find the last cell containing data, and fill the next blank with "0" (highlighted in orange).
Solved by F. A. in 30 mins
Hi, we have an excel file with five columns. We need HTML to be inserted before and after each column. It's the same HTML for all. Then we need all five columns to be combined in one column. Attached is the file. Please Advise Thanks
Solved by O. E. in 26 mins
I want to make the cell column width different of various parts of the sheet
Solved by Z. Y. in 18 mins
Hey, my excel column says July but on the chart it keeps coming up as April? why
Solved by X. J. in 13 mins
i need such a formula so that i enter figures in one column and their addition should be result in another column.as it upto date with next day entry i send 2 sheets kindly check it
Solved by C. J. in 15 mins
I am trying to remove duplicates in column A and add the data from the duplicates in column B and compress it all into one row.
Solved by K. H. in 12 mins