|
|
#1
07-24-2013, 06:42 AM
|
|||
|
|||
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. 
|
|
#2
07-25-2013, 01:35 AM
|
||||
|
||||
|
In the Pivot Table use the Risks as row fields and the requirements and dangers in the data field
Make sure the COUNT function is selected for the data fled settings
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
07-25-2013, 06:17 AM
|
|||
|
|||
|
Yup
Perfect and easy as pie. Thanks.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 message unique number
|
zemestan | Outlook | 1 | 10-20-2013 04:57 AM |
| Labeling sequential forms with a unique number | krau0231 | Word | 1 | 10-18-2012 03:33 PM |
| Count number of emails from each category | HxG | Outlook | 0 | 09-19-2012 11:55 PM |
|
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
|
generate unique number on same document when printed
|
benjii19 | Word | 1 | 03-08-2011 12:38 AM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
