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