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