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!”
Here are some problems that our users have asked and received explanations on
Move cell value to different rows and column if there are multiple rows for a customer
Solved by B. J. in 21 mins
I want to know if there is a function that provides the overall amount of weight loss out of each submission in an a entire column. Just like how at the end of a column you can do the sum or the average, etc. I want it to constantly be able to provide a new number by subtracting every time I put a new number in the column.
Solved by G. L. in 20 mins
I'm have two columns with different values - one column has country names, another column has Y (or is blank). I want to find a formula to count the specific name if there if there is a Y in the same row as a country name.
Solved by B. J. in 19 mins
Excel question = If data in sheet 1, column A matches data in sheet 2, column A, then I need it to pull data from sheet 2 column B and place it into sheet 1 column c. what is the vlookup column formula for this?
Solved by B. J. in 17 mins
Is it possible in a spreadsheet to enter the first date of any month (mm/dd/yy) in a column that has 31 cells and Excel (I'm guessing with the help of a formula) automatically filling in the rest of the days that are in that month only? For example, if I put 02/01/2017, will Excel only fill in the number of days for February without proceeding to the next few days of the next month?
Solved by M. U. in 16 mins
I would like to shade a cell in a column of a sheet if the same data exists on another sheet
Solved by O. Q. in 11 mins
Hi, i have wording in a column and would like to delete part of this wording and save the residual in another column. eg. "Owner:Wattgrove Pty Ltd" I need to remove the "owner". I have a number of fields and just a "left or right" equation wont work. ??
Solved by G. J. in 25 mins
I have a column in excel with URLs which I want to filter out by copying/pasting existing URLs that I've already gone through so they get deleted from that column
Solved by I. Q. in 29 mins
I'm trying to extract email addresses from a column of text into a new separate column
Solved by A. A. in 28 mins
I'm having a problem coming up with a function that will insert the value of a cell based on whether or not the min excel value in the row belongs to the column.
Solved by Z. Y. in 27 mins