Get instant live Excel expert help with Pivot Tables
“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
I need help with pulling these two sheets into 1 using the store number as a point of reference and then doing 3 pivot tables
Solved by K. U. in 21 mins
I need to get 4 different pivot tables created off this sheet
Solved by B. F. in 20 mins
I have created a audit in excel with column A frozen with the questions in, the following columns i have added data validation with drop down answers to the questions. in row 2 i have a sequential weekly date beginning on 05/06/2017. i also have multiple pages with the same parameters in but different names for the worksheets. i would like to create a pivot table pulling 1 months worth of data from each worksheet so i can quickly scan the results of each worksheet
Solved by Z. S. in 15 mins
how to categorize data without using Pivot Table, I want to use formulas to fetch the detail
Solved by E. Y. in 13 mins
I'm new to pivot tables and just the basics are stumping me. just getting 3 columns it doesn't go where I want to.
Solved by T. B. in 20 mins
Hi, I'm trying to create a complex pivot table with a very large amount of raw data and having trouble.
Solved by G. J. in 21 mins
How do you do pivot tables in Google Sheets?
Solved by A. F. in 13 mins
I have a pivot table and I need to show the ytd total of customer satisfaction rating for a number AND next to it (same chart) only the current week.
Solved by Z. Y. in 17 mins
Need a formula or pivot table to compare if the data in column A of the "MY9 Extraction" exist on the worksheet labeled x-chart. The number can exist multiple times in multiple locations. I just need to know if it exist at all on the xhart worksheet.
If it exist entered Yes, if not enter No.
Solved by K. S. in 12 mins
I need help creating a pivot table so it looks like this:
Create a table that counts the number of responses to the question, “Which of the below flavors of ice cream do you like?” Show the flavors on the side, and the gender on top of the table. Hint: you may need to drag/move “Σ Values” to a row or column area in order for this to work. Also, can you change the row values to a custom name? Change the name of each flavor so that it only shows the name of the flavor and not “Count of [flavor name]. For example, change “Count of Chocolate” so it only reads “Chocolate” (Hint: in the Custom Name field in “Value Field Settings”, you must use a space before or after the name of the flavor for this to work).
Solved by Z. F. in 24 mins