# 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!”

## 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 help with this problem and please don't leave until I have the information Create a table that shows the average rank of the question, “Rank the following ice cream flavors.” Show the flavors on the side, and gender on the top of the table. Change the name of each flavor so that it only shows the name of the flavor and not "Average of [flavor name]."
Solved by M. J. in 20 mins
i have sheet with names with yes and no next to them. i want to have one table to show all the yes and no names what formula do i use
Solved by F. H. in 28 mins
I have a column in a table with 5 different values and a different column in the same table with either a yes or no value. I want to count the amount of times , one of the 5 values in the first column has a yes value against it in the other column
Solved by K. L. in 29 mins
I am trying to create a lookup formula in excel. Where I have a table full of prices for various jobs to do on various phones at work. So for example If i had one cell say iphone 5, and another said screen, the result would be the price I am looking for, and would be able to change based on what the 2 cells say, different phones and different jobs.
Solved by V. W. in 28 mins
I am trying to pick item sales values from table, which has two references, one is year, other is product. I am able to get sale value with V lookup for one reference (product), however I am struggling to get corresponding value of product for different years (Years are in column, products are in rows)
Solved by T. S. in 27 mins
I am trying to sum the amount each customer has ordered in my excel document by creating a table.
Solved by T. J. in 29 mins
I have a pivot table running of a set of call center data table. The pivot tabulates a monthly count of calls per product. I want to insert an additional column to calculate the average of the monthly count of calls and to flag any cell where the average is less than any of the preceding months call count.
Solved by S. H. in 15 mins
I have a pivot table running of a set of call center data table. The pivot tabulates a monthly count of calls per product. I want to insert an additional column to calculate the average of the monthly count of calls and to flag any cell where the average is less than any of the preceding months call count
Solved by E. J. in 11 mins
Hi, I'm having a problem with a pivot table that wont produce the summery of the data that i require. I need to be able to filter the 'divisions' to provide the number of 'yes', 'no' and 'n/a' to a given question 'Q1', 'Q2' etc. When I have used a pivot table there doesn't appear to be enough options to count the number of text answers. Instead it only counts the number of one of the columns and replicates the data?
Solved by Z. B. in 19 mins
I would like to make a table from drop down list with vlookup function
Solved by C. Q. in 15 mins