“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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