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 need to get the difference between columns g and h form g1 to g770 and h1 to h770 showing the difference in each individual line is this possible ??
Solved by O. H. in 17 mins
I have a 2 columns that I need to summarize everything that has data in it. Is there a way to create a summary table with only questions that were answered?
Solved by O. Y. in 21 mins
I have 2 rows of information, I need to create a sheet that will convert the rows to columns automatically.
Solved by M. C. in 16 mins
I need to format a number like the following: 24567.44 to show as $24.6 but I do not want to add helper columns just want simply format the row. Currently excel keeps adding a , rather than a . when I try to format.
Solved by A. Q. in 14 mins
Hi I need to sort the attached in file in to four new files or tabs, based on certain columns
Solved by B. A. in 17 mins
How do I copy cells on one sheet that are in columns to another in rows, linking them to the first sheet?
Solved by C. U. in 28 mins
I have a workbook that I want an opinion/ ideas on the layout One sheet is data that is coming in via a google form. Because the data comes in across the columns I have created another sheet that copies the data down the rows, along with a summary table. The summary table is where I will be getting the information for the rest of my workbook. I would like it if there is a way to set this up so if I change the questions on the form it is quick and easy to link up my second page. In a perfect world it would do it automatically. I will paste in the two sheets. Thanks
Solved by I. J. in 16 mins
I need to get the columns from having a formula around them. I really am not very good on this.
Solved by O. H. in 27 mins
In the following formula = VLOOKUP ($ BQ $ 29, 'AP1 FO'! $ A: $ AY, 7.0), I need to drag the col_index_column, 7, 8, 9 and so on when drag to the right. I have 100 columns and it will take forever if I change it manually.
Solved by O. F. in 19 mins
Autofit columns A:M. Set the orientation to Landscape, set the Width to 1 page, center the worksheet Horizontally. Insert a footer with the file name in the left section and page number in the right section
Solved by S. W. in 18 mins