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!

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
I am trying to create a Pivot Table in Excel. I have very limited knowledge of Excel and I am having a difficult time creating one.
Solved by K. L. in 60 mins
Pivot table compares codes from one worksheet to another worksheet however it will only recognize alphabetical or alpha-numberic codes (not numeric codes only).
Solved by G. W. in 27 mins
I need to consolidate a list of names based on lowest number. Each name is associated with an account and a date. For each account I need only the lowest date to show up. I am using a pivot table.
Solved by C. H. in 60 mins
I need to create a pivot table that sums visits per day by provider: Date...Visits....Provider So, I can many visits did provider X have on day Y?
Solved by F. J. in 34 mins
I want to edit added calculated fields on a pivot table. It is possible to manually enter values to calculated fields on a pivot table? If not, is it possible to insert an editable column on a pivot table?
Solved by Z. S. in 20 mins
I have a dataset and pivot tables. Charts not changing when downloaded on a different computer
Solved by Z. D. in 60 mins
1 2 3 5 6