Microsoft Excel is a powerful spreadsheet software program that is often used to compile and manipulate large amounts of data. Excel offers a feature known as the Pivot Table, which is an interactive table that will automatically extract, organize and summarize data for you. You can utilize Excel to count all the distinct records that occur in any of the Pivot Tables you create.
Add a column to the database with which you are working; give it a text heading of your choice and add this field to your pivot table.
Enter the following formula in the first cell of the column you created:
where A is the column which you are searching and 2 is the first row of data in your pivot table.
Copy the formula down the entire column you created and the cells in that column will display the number of distinct records in that row.
- Photo Credit computer image by Ewe Degiampietro from Fotolia.com
Definition of a Pivot Table
A pivot table is a handy tool for summarizing data, featured in many spreadsheet programs, such as Microsoft's popular Excel package. Pivot...
How to Summarize Data in Excel
There are several ways to accomplish a single task in Microsoft Excel. Three different ways to summarize the data on your spreadsheet...
How to Count Entries on a Pivot Table
Pivot tables are spreadsheet tools used to summarize a larger data table into a smaller one. In Excel, the default is to...
How to Extract Pivot Table Data
A Pivot table allows a user to summarize and organize large amounts of data. Pivot tables are used to discover sales trends,...
How Do I Use Pivot Table in Excel?
Microsoft Excel pivot tables provide a way to quickly summarize data. The user can summarize the data to find an average, sum...
How to Count the Number of Unique Values in a List in Excel
If you have a list that contains duplicate values, it may be difficult to count how many unique occurrences of values are...