Excel Tips
What Happened to Multiple Consolidation Ranges in Pivot Tables? »
February 9, 2023
Microsoft seems to have eliminated the PivotTable and PivotChart Wizard in Excel 2007, so now how can I select Multiple Consolidation Ranges?
Create a Pivot Table from Access Data »
February 8, 2023
I have 10 kazillion records in an Access table. I would like to create a pivot table for this data.
Fix Misspelled Customer Names »
February 7, 2023
I collect data from sales reps. There must be a half dozen ways that they enter General Electric.
Use a Pivot Table When There Is No Numeric Data »
February 6, 2023
My data set contains a list of manufacturing defects found in quality inspection for one month. I have fields for date, manufacturing line, and defects. There are no numeric fields. Can I analyze this data with a pivot table?
Use a Pivot Table to Compare Two Lists »
February 3, 2023
I have two lists of data. One is from a forecasting system. One is from our order entry system. I want to compare both list. Although both lists happen to have twenty customers, they are not the same twenty customers.
Create a Unique List of Customers with a Pivot Table »
February 2, 2023
I need to create a unique list of customers from a large list.
February 1, 2023
I built a pivot table to show sales by month for one customer. For the large customers, I get all 12 months.
Show Customer Account & Name »
January 31, 2023
My source data comes from the sales reps. They don’t use consistent names, so I end up with multiple customer names for one account number.