Are you stuck on Excel or Google Sheets?

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

I have a project which requires me to calculate lifetime value using pivot tables, sumifs and indexing.

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?

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

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)

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?

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.

I have a problem on creating a bubble chart from a pivot table.

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

How to create a excel in a cell same as pivot table