# 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

Example --- I have a a Cell Y13 with the following formula in it. =IF(V13="","",W13-X13) which works well (stating - if V13 is blank leave blank, if not then subtrack w13 from x13 and enter that instead) however, I want to include another cell AN13 - I need the formula to look at AN13 first and if there is a value in AN13 put the word "Completed" if not then follow the first formula. I would also like to create a Status column that would compute On Track or Past Due depending on what the last step is showing. - Example line 16 Step 1 shows on track but step two is past due so the status would be past due. However if the first step showed "past due" and the second step showed On track the status would show "on track". I would like to have it look at the last step entered for all 7 steps Z-AL to compute the correct status
Solved by O. J. in 15 mins
i have a column filled with a lot of text i need to break it and bring certain sentence on another column
Solved by G. H. in 29 mins
Hi there, I'd like to be able to paste the values from one column in a worksheet to a set group of cell in another. In this instance, I have a column of 27 cells in sheet 1, and I'd like to paste one cell every 27th row in teh data tab. So, the value in Sheet1 - A1 would paste to Data tab - E3, Sheet1 - A2 would paste to Data -E29 etc.
Solved by O. Q. in 17 mins
need macro in D column to spell word in Column 2 backwards so 4th column will have the words in column 2 spelled backwards
Solved by M. H. in 18 mins
I'm trying to fill data from once tab in a workbook to another. I would like to be able to drag to the right and have the ROW number increase incrementally but keep the column the same.
Solved by F. S. in 17 mins
Column BP7 needs to find the minimum value between cells G7:L7. Between G7 & L7 is two results, I have "39" in K7 and "56.39" in L7. Clearly, K7 is the minimum value and should be the result from my formula in BP7, however it is "56.39" that is being displayed! When I force the formula to only read cell K7, it returns the result as 0.00. Please help, I cannot figure this out!
Solved by F. D. in 16 mins
I would like to be able to lock in a date/time stamp in excel. when I enter a name in the 'completed by" column, I would like the date/time to appear and lock so it cannot be changed. Please see tab SOD Tasklist 2 to work on. I read that a VBA script can be copied and pasted. I tried it but go errors. Also it requires the sheet to be protected but I cannot have it protected. Can this be done? Thanks
Solved by B. B. in 28 mins
I need if column B paye sum( D+E+F+G = H
Solved by I. B. in 24 mins
Need VLOOKUP HELP. Trying to match the values in column A to a table range (AB:AD) . when the account number is found in the range, I want it to return the value in AD.
Solved by M. C. in 13 mins
I would like help linking a certain column or individual wording to a numerical value
Solved by E. U. in 12 mins