Get instant live expert help on I need help with two way data table 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
using a two way chart to create a data table
Solved by K. H. in 16 mins
I have three tables on three different worksheets. One table is an input table where the data is entered, and the other two tables use the data from the input table to make calculations. Is there a way to get the calculation tables to autoexpand when a new line of data is entered into the input table without using VBA?
Solved by O. A. in 29 mins
I would like to create a third table where the calculated values are a result of dividing data in pivot table 1 by data in pivot table 2. I want to do it this way so when I move rows around in the first two tables and the first two tables adjust, I would like the third table to adjust in similar fashion so I don't have to deal with manual adjustments.
Solved by G. H. in 27 mins
I need help with data validation on a table in excel. I want the user to be required to enter data in two columns (blanks are not acceptable). The data is in a table (not a range). The two columns are C and E. These two columns auto-populate based on the input in columns B and D respectively.
Solved by B. W. in 27 mins
Construct a one-way data table with production volume as the column input and profit as the output. Vary production volume from 0 to 30,000 in increments of 5,000 then Construct a two-way data table with production volume as the column input, Revenue per unit as the row input, and profit as the output. Vary production volume from 0 to 30,000 in increments of 5,000. Vary revenue per unit from $1.00 to $2.00 in increments of $0.10.
Solved by A. L. in 19 mins