Link to home
Start Free TrialLog in
Avatar of WeThotUWasAToad
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:

User generated image
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:

User generated image
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
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
See screenshots....

User generated image
Avatar of WeThotUWasAToad
WeThotUWasAToad

ASKER

Thanks for the help.