WeThotUWasAToad
asked on
Use a PivotTable to determine how many times a particular value occurs in a column in Excel
Hello,
How would you set up a PivotTable to tell you how many times a particular value is present in an Excel column?
For example, suppose rows 1 thru 1000 in column A each contains a single letter of the alphabet as shown here:
To determine how many times each letter occurs, I would typically list the letters of the alphabet in a separate column then use a COUNTIF() function in an adjacent column in this manner:
However, I suspect that there is a way to determine the same information using a PivotTable. If so, what are the steps to obtain the desired result?
Thanks
How would you set up a PivotTable to tell you how many times a particular value is present in an Excel column?
For example, suppose rows 1 thru 1000 in column A each contains a single letter of the alphabet as shown here:
To determine how many times each letter occurs, I would typically list the letters of the alphabet in a separate column then use a COUNTIF() function in an adjacent column in this manner:
However, I suspect that there is a way to determine the same information using a PivotTable. If so, what are the steps to obtain the desired result?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See screenshots....
ASKER
Thanks for the help.