Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Chapter 24. Summarizing Data with PivotT... > Create a PivotTable with Non-Numeric... - Pg. 498

Create a PivotTable with Non-Numeric Data lthough most PivotTables are created from numeric data, numeric data is not necessary to create a PivotTable. You can create a PivotTable using non-numeric data stored in a range, a table, or an external data source. A PivotTable that summarizes non-numeric list information counts information instead of summing it. Suppose that you have generated a mailing list that contains name, address, city, state, and Zip code information for 75 people. None of this information is numeric, Zip code notwithstanding, but you can use A the information to create a PivotTable that counts information rather than summing it. For example, using this information, you might want to know how many addresses appear in each Zip code, or you might want a count of the number of Zip codes associated with a particular city. Just viewing the worksheet in its native form would not help you analyze any of the information. You could set up functions to answer your questions, but doing so would be more work than creating a PivotTable. A PivotTable can help you quickly and easily answer all of those questions.