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!

need to learn pivot table v look up and h look up
Solved by B. B. in 20 mins
How can I create PIVOT Table for a large data having merged cell and free spaces, please
Solved by Z. L. in 29 mins
Tell me details about Pivot tables. Specially where it is used?
Solved by C. Q. in 26 mins
I need help with pivot tables, I can provide an example
Solved by A. Y. in 20 mins
Pivot Table formats and functions are lost after my file is saved. Even older versions of the file that had opened fine before will not now. What gives?
Solved by V. D. in 60 mins
Hi, I have a problem with pivot table and conditional formatting please help
Solved by V. C. in 20 mins
I have 4 columns of data, with each row showing one set of data. Then another 4 columns of the same type of data, but for the next month, then another 4 for the following month, etc. It is organized like this so it can be pulled into another sheet. However, I want to analyze this data for the whole year, with pivot tables (also charts, etc), but if I make a pivot table of this data, it makes the columns with the same title another group (month, month2, month3...). I am come the data from each month onto another sheet, so that it is all in just 4 columns. Could you help with this
Solved by O. D. in 60 mins
i need someone to get me through the basics of pivot tables
Solved by M. A. in 52 mins
I need to add a field to my pivot table that includes the difference between values in two columns
Solved by E. A. in 40 mins
I'm dealing with a company with over 20 owners who receive payments every pay period. They take 10% of the payment to leave in the business. Each pay period is on a separate tab in excel. I'm trying to come up with an easy way to track how much each owner has been paid, and how much they've left in the business (10%) cumulatively across the tabs. Could I use a pivot table to do this? Or Vlookup somehow? I guess I'm stuck because it's across so many tabs, and the tabs for the pay periods that haven't happened yet haven't been created yet. Thanks!
Solved by V. L. in 60 mins
1 2 3 4 5 6