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!

Hi, I needs the urgent help on how to hide the negative time value from pivot table of excel sheet
Solved by E. U. in 35 mins
Good Morning I have data with multiple pivot tables. I have a slicer with date ranges, example 07-29-18 to 08-11-18, that brings the data together with this date range. When I choose this date range the data shows blank. When I choose Blank on my slicer the data shows up. I have removed the data and re-entered it. File is very large and has been working up to this date. If I go to the next date range I get the data
Solved by M. L. in 23 mins
I want to learn how to use pivot tables, slicers, Vlookups and charts
Solved by D. B. in 11 mins
I have a database extract that is showing the same clients multiple times in the list. How can I write a formula in excel to look at the column with the client names and return only unique records on another sheet? I want to run this over several files so wanting to avoid using pivot tables which is how I would normal do this.
Solved by X. J. in 20 mins
Need a calculated field in a pivot table that finds the difference between two "count" value fields
Solved by K. S. in 60 mins
Is it possible to unpovot part of a Pivot table.
Solved by M. H. in 4 mins
Hi. How can I do a Pivot Table on a Google sheet?
Solved by M. C. in 4 mins
I hid a few rows on the top of Pivot table in Excel and cannot unhide them now. I have tried a few ways described in the web but nothing worked out so far. Please could you help?
Solved by F. A. in 20 mins
Hey there. I can't find a easy way to generate a pivot table exactly as i want to see it. I might need some calculated column but i'm never used this feature and i'm not sure.
Solved by M. Y. in 12 mins
Hello, I tried to attach my spreadsheet bit it is too large. I built a power pivot table with a customized formula and everything looked really good but when I try and update the information for the new day the only thing that comes up is the error #NUM!. I am struggling understanding why the formula works for data that was in the spreadsheet when I made it but any data that I update it with gives me the error.
Solved by S. Y. in 21 mins
1 2 3 4 5 6