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 have two worksheet in one work book. I want sheet one to access information from sheet two. So I have Sheet One Column A I want to enter a title and in column B I want a corresponding code based on what was entered in sheet 1 to be entered in column B sheet 1 from column B Sheet 2. Then I want a number to come up in column C based on that code in Column B that is from Column F on sheet 2
Solved by K. E. in 26 mins
I need to add tow column "B" and "C" in "P"
Solved by S. H. in 16 mins
I WOULD LIKE TO ADD A COLUMN TO AN EXISITING SPREADSHEET THAT WOULD AUTOPOPULATE THE MONTH OF THE YEAR AND THE DAY OF THE MONTH - I CELL WOUDL POPULATE THE MONTH AND WHEN YOU SELECT THE MONTH THEN THE COLUM BELOW WOULD AUTO PULATE THE DAYS IN THAT MONTH IN NUMBERS
Solved by K. Y. in 26 mins
one column (a) is todays date: B Column is todays time: C column is data entered time: D Column needs to subtract Column C from Column B for a difference of time left Cant seem to codes this right can you help us
Solved by D. H. in 23 mins
Is it possible to use excel to data entry on a website. I have one column that has various names, the other two columns that have the same name. When I open the website to place the information onto the website, I have to copy each line, hit submit and continue to do it three times to finish one line. Is there a way to automate this process
Solved by O. J. in 22 mins
Could you please explain command by command the total function entered in column D? I originally got the formula from google with the task of assigning a unique serial number to each investment, and I wanted to understand how the original person went about creating the function. It'd be greatly appreciated!!!
Solved by O. E. in 21 mins
I want to make a formula that performs a wiki or google definition search based on the adjacent cell. I want to be able to apply it to a large amount of data in a column.
Solved by T. J. in 20 mins
I inserted a row in the middle of an excel spreadsheet where I want to type text that will not fit into the column width. What do I need to do to allow the text I want to enter?
Solved by T. Y. in 11 mins
I need help inexcel conditional formatting based on another cell color. In the file, the cell will not show based on there not being text in the 'Student Column", but the cell color coded with a uniform color if no data appears.
Solved by O. F. in 27 mins
I need to know how to format a formula to make all cells with no 'Text' in another column not appear. Here's the formula as it currently is: =IF(AP8<0,"Worse",IF(AP8>0,"Better",IF(AP8=0,"None")))
Solved by T. Q. in 26 mins