Get instant live Excel expert help to learn how to create and adjust tables in Excel?

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]."

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

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

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.

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)

I am trying to sum the amount each customer has ordered in my excel document by creating a table.

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.

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

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?

I would like to make a table from drop down list with vlookup function