How to get count summary of number that corolates with a name?

[Neall]

I have a column that has multiple divisions (groups), and another column that
has the severity level for that particular item (could be 1,2,3).

Example

Group Severity
CAT 1
DOG 1
FISH 3
CAT 2
DOG 3
FISH 3
CAT 1
DOG 1
FISH 2

Now on a summary page I want to give the results like this

Animal Sev1 Sev2 Sev3
Dogs 2 0 1
CAT 2 1 0
FISH 0 1 3

Any suggestions on how to pull that into a summary page, I was thinking
Vlookup but it doesnt seem to do eveything I want.

Thanks in advance

 

[Ron Coderre]

Try a Pivot Table:

Using your data, as structured with column headings

From the Excel Main Menu: <Data><Pivot Table>
Use: Excel..Click [Next]
Select your data..Click [Next]
Click the [Layout] button

ROW: Drag the GROUP field here
COLUMN: Drag the SEVERITY field here

DATA: Drag the SEVERITY field here
If it doesn't list as Count of SEVERITY...dbl-click it and set it to Count
Click [OK]
Select where you want the Pivot Table.Click [Finish].

That will list the count of each intersection of GROUP and SEVERITY.

To refresh the Pivot Table, just right click it and select Refresh Data

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Neall]

Excellent thanks, I used to work for a BI company that designed Data
Analytics software, guess I should stop using standard query's and go back to
data mining using the pivot tables now that excel 03/07 seems to have much
better data analysis functionality.