Get instant live Excel expert help to learn how to create and adjust tables in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Enter values in D6:D15 from 1800 to 3600, step of 200; apply Blue font color and Comma style with zero decimal places
In range D5:F15, create a one-variable data table with B7 as Column input cell
Solved by A. D. in 25 mins
I need to learn how to add pivot table in excel
Solved by V. Q. in 30 mins
I want to create a VBA loop that moves row by row, from H4:Q4 to H23:Q23, and ADDS the values in cells H186:Q186 to H205:Q205. I want it to run this loop until certain conditions are met in the table containing cells B3:E24.
Solved by G. Y. in 21 mins
Good Morning, I have created a database in Excel that utilises a form and VBA programing to populate the document, however when you click OK on the form it does load the information into the table however it places the data into random rows leaving blank rows in the table.
Solved by O. D. in 16 mins
Data filtering - sheet has 8 cols 865 rows and will not show whole table, 1st 182 columns cells highlighed blue
Solved by A. B. in 25 mins
I would like a vale displayed based upon the vale of an adjacent table
Solved by X. J. in 11 mins
i just need help creating a chart that highlights all the data in the table.
Solved by I. W. in 20 mins
As you can see from the spreadsheet I have social needs and up to 4 agency referrals made for each social need. Sometimes a referral is made only to one agency or up to 4 referrals. I am trying to create a pivot table and chart to display this. Because there is 4 different columns for agencies I am having a hard time to combine the agency rows with out loosing the social need that is was created for. I am looking to count the agency referrals made for each social need. Hopefully this makes sense. Thank you for your time.
Solved by F. A. in 17 mins
I just need a pivot table from 2 rows of info
Solved by A. W. in 14 mins
Hello, I am having trouble getting my table to work.
I have a heading at the top of my table as a drop down menu for 3 sale options. I need these linked to corresponding product list in column 1, with product prices to automatically appear in column 3.
I have all the data for the 3 sales options (products and prices) input into 3 tables on a separate worksheet as well as the options for the top bar of the table.
Solved by X. F. in 18 mins