Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I have a pivot table in which per order (on the rows) stands how much products they ordered per size (on the columns). I want to determine which combinations of quantities of sizes people order. And I want to count these combinations.
Solved by E. W. in 60 mins
I need help making my pivot table look cleaner and filtering some information
Solved by S. Q. in 60 mins
Ok, I am trying to create a running workbook where I have data in different tabs (each tab is one month) that I want to add values to, and create a ytd summary tab that will track how much is being spent for each month, I am attempting to use the data model pivot table tool but am having trouble building the relationships, is there an easier way to do this ?
Solved by Z. Y. in 60 mins
We are trying to create a pivot table and combine two separate workbooks, that do not have the same data in the same cells. Is this even possible? For example the data is sales on items by month, one workbook has the sales broke down by month, the other work book has sales broke down by week. We can convert the data, before hand, but we are trying to forecast sales of times.
Solved by T. L. in 60 mins
I'm making a a pivot table with a chart. specifically a pie chart. I have multiple data to compile into one. The data I compiled is for retail stores. pertaining to inventory. within those stores I have reasons for adjusting the inventory. Then the cost that was adjusted. How do I get all the info in the pie. The pivot table looks good. Can't get the pie to reflect
Solved by A. Q. in 20 mins
I can not make a pivot table keeps saying I do not have colums
Solved by M. H. in 24 mins
Please assist I have numbers in an excel sheet but the numbers cannot be added up, the numbers appear as a 0 on my pivot table. I have tried the ALT + 0160 trick but its not working. Please assist
Solved by A. A. in 16 mins
i have a pivot table and it is showing 0 for amount values
Solved by S. H. in 45 mins
I have an existing Pivot Table of Sales Data. Item ID is a filter, but not visible in my table. I have a separate workbook with Item ID, Class A, Class B. I want to "unpivot" VLOOKUP to get Class A & Class B columns into Table Data (by Item ID), and then recreate the Pivot Table.
Solved by M. J. in 26 mins
I have a data and wanted to create pivot tables
Solved by M. D. in 22 mins
1 2 112 113 114 128 129

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc