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 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
I have two very large sets of numerical data on the same excel file but on two different sheets and I need to compare them and highlight any differences. Data Set number 1 is all just in one column, But data set number two is also in one column but there is a lot of other data that is not relevant. I used a pivot table, to sum up all of the numbers I needed in Data set 2 and then I summed up the numbers in data set 1 and there was a difference so I need to have excel highlight that difference
Solved by M. H. in 57 mins
I have a project which requires me to calculate lifetime value using pivot tables, sumifs and indexing.
Solved by O. L. in 60 mins
I need to be able to convert a pivot table of 4 columns and 100 rows into two tables of 4 columns and 50 rows each? How might I do this?
Solved by X. F. in 20 mins
1 2 4 5 6