Thread: [Solved] Display unique values and count the number of child items
View Single Post
 
Old 07-24-2013, 06:42 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default Display unique values and count the number of child items
I have a spreadsheet that has three columns Risk, Requirement, Danger. The spreadsheet is sorted alphabetically by Risk. I want a new sheet that

- List the Risks discreetly.
- COUNTS the number of Requirement and Dangers that belong to that risk.

Pivot table? All the pivot table examples show analyzing numeric data, and I am having a hard time grasping how to do this.

Thanks.
Reply With Quote