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!

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
I want to calculate an average of some values in a pivot table, however I cannot do that as some rows contain blanks.
Solved by I. C. in 58 mins
I need help to rearrange data in excel. I have 7 columns with days of the week, the 8th column is weekend date. The rows are hours. What I want is a list of dates and the associated hours next to it so I can run a pivot table easily off it
Solved by T. W. in 60 mins
Need to calculate a rolling 4 week average in pivot table
Solved by X. B. in 40 mins
1 2 4 5 6 7