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 to pull employee numbers and names and match them on a new worksheet using pivot table?
Solved by S. H. in 20 mins
I am trying to get a pivot table to add the amount of fees for separate months from separate spreadsheets. I was trying something with the Pivoting Wizard, but it was too much for my 32 bit Excel.
Solved by K. A. in 11 mins
Ok, I am trying to create a running workbook where I have data in different tabs (each tab is one month) that I want to add values to, and create a ytd summary tab that will track how much is being spent for each month, I am attempting to use the data model pivot table tool but am having trouble building the relationships, is there an easier way to do this ?
Solved by V. Y. in 40 mins
can not turn my data into a pivot table... reference invalid
Solved by I. B. in 39 mins
I have a pivot table in which per order (on the rows) stands how much products they ordered per size (on the columns). I want to determine which combinations of quantities of sizes people order. And I want to count these combinations.
Solved by E. W. in 60 mins
Ok, I am trying to create a running workbook where I have data in different tabs (each tab is one month) that I want to add values to, and create a ytd summary tab that will track how much is being spent for each month, I am attempting to use the data model pivot table tool but am having trouble building the relationships, is there an easier way to do this ?
Solved by Z. Y. in 60 mins
I need help making my pivot table look cleaner and filtering some information
Solved by S. Q. in 60 mins
We are trying to create a pivot table and combine two separate workbooks, that do not have the same data in the same cells. Is this even possible? For example the data is sales on items by month, one workbook has the sales broke down by month, the other work book has sales broke down by week. We can convert the data, before hand, but we are trying to forecast sales of times.
Solved by T. L. in 60 mins
I'm making a a pivot table with a chart. specifically a pie chart. I have multiple data to compile into one. The data I compiled is for retail stores. pertaining to inventory. within those stores I have reasons for adjusting the inventory. Then the cost that was adjusted. How do I get all the info in the pie. The pivot table looks good. Can't get the pie to reflect
Solved by A. Q. in 20 mins
I can not make a pivot table keeps saying I do not have colums
Solved by M. H. in 24 mins
1 2 5 6