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'm trying to sum up numbers in column 3 but only if column 2 holds a 'Y'
Solved by B. D. in 19 mins
When I indicate a follow up date in a column, I want those companies to appear in a specific cell once the follow up date matches today's date.
Solved by G. J. in 23 mins
Hi There, I want to collate different values from one column to different column
Solved by C. S. in 20 mins
I need help calculating column E. Criteria specified in F - you can add additional columns if you need to.
Solved by O. W. in 13 mins
Hi there! I'm basically really struggling with Excel VBA. I am trying to create an excel sheet which scrapes the code from a web page onto it. I then need this to refresh frequently using a timer, and then send me a notification if any changes have been made to the source code, letting me know that the website has been updated.. Could you help me with this? So far I have recorded a macro which pulls in the web data and have got that on a timer, but every time it runs the web info is put in a new column, rather than refreshing the old info.... Please help!!! Thanks
Solved by V. B. in 29 mins
I need to create a spreadsheet where I need to locate different diameters (In Column) with different holes (In row). I need to create a formula where i type in the Diameter number it should lock that column and when i enter the hole size it should correspond with that column.
Solved by T. W. in 20 mins
Hello, I am trying to keep a balance column that adds and subtracts values from credit and debit columns respectively. Is there a way to do this?
Solved by F. B. in 13 mins
Currently using an excel spread sheet to create a database of parts and their parts numbers, as well as the contact information of who to contact to order the part. I have a pivet table set up and in column A i have all the parts going down, and then the plus/minus buttons are clicked to reveal the contacts/phone/email to get ahold of it, again this is all in column A via the compact form report layout. Next i am trying to find a way to insert addition information such as order frequency etc, in column BCDEF. I want them to be attached to the pivot table so that i can easily update and insert information. If i were to insert the frequencies next to the table but not in it, when opening the plus/minus' in column A this then throws the rest of the document out of wack and isnt aligned correctly. How would i go about inserting this information in a column connected to the pivot table and its corresponding parts without changing out of the compact view because of printing aspects and clarity.
Solved by F. C. in 12 mins
I have a spreadsheet with data that I want to copy and split into multiple sheets based on values in a specific column
Solved by M. F. in 30 mins
I have two columns grower # and farm name. I have one listed a the Legend on one tab. The other tab is sheet1 when on sheet 1 I want to be able use a drop down click on the that grower number and the farm name drops down in the other column under farm name.
Solved by Z. F. in 25 mins