With your source data in columns A and B with headings of Type and Amount,
add a new heading to column C called Frequency
In C2 enter
=COUNTIF($A$2:A2,A2)
and copy down for your entire set of data
Place your cursor on the header row>data>Pivot Table>Finish
On the new skeleton Pivot Table grid that appears,
drag Type to the Row area
drag Frequency to the column area
drag Amount to the data area
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
