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 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
I want to only count unique instances of an array in a pivot table. For example client A has been invoiced twice for Product B and 3 times for Product C. I want to count the fact that Client A has used Product B and Product C ( ie a value of 1 for each) and not 2 for A and 3 for B
Solved by G. U. in 60 mins
How can I set up a pivot table to show "count of" totals by year across different columns (instead of just filtering year by year)
Solved by O. E. in 19 mins
I have a pivot table with data points per month and I am putting that into a spreadsheet (a budget). My problem is that I can't figure out to escalate each data point per column, i.e. ='Pivot Table 1'!E3 then the next column pulls from ='Pivot Table 1'!E4, the next ='Pivot Table 1'!E5...SO, how do I write a formula the right way?
Solved by E. C. in 11 mins
I added data to my table. Ive refreshed the pivot table but when I access "builder" within the table, I don't see my new column listed.
Solved by B. C. in 39 mins
I have a problem on creating a bubble chart from a pivot table.
Solved by V. Y. in 22 mins
Just wondering how I insert a pivot table, i know how to do in excel but can't find a similar function using Google Sheets
Solved by D. F. in 30 mins
How to create a excel in a cell same as pivot table
Solved by S. B. in 20 mins
1 2 5 6 7