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 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
I have a data and wanted to create pivot tables
Solved by M. D. in 22 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 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 need to create a pivot table that sums visits per day by provider: Date...Visits....Provider So, I can ask...how many visits did provider X have on day Y?
Solved by F. J. in 34 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