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!

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
Hi, I have one Question, If Pivot Table already has been made and if I will Add another data in Pivot table sheet so Automatically Pivot Table chart will be changed?
Solved by E. Q. in 23 mins
I want to add ranking column in my pivot table. I used rank formulas in calculated field but it just #N/A. How to calculate ranking based on the value in pivot table?
Solved by E. W. in 44 mins
I have a data sheet and need to change dates/times from UTC to PST and then create pivot tables for data analysis.
Solved by C. H. in 40 mins
I want to create a double bar graph from an existing pivot table, but excel won't let me simply add a new field for the column labels and manually put in numbers. What can I do?
Solved by C. F. in 18 mins
1 2 115 116 117 128 129

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc