hi, dnot' really know how to get this done.

Same workbook.

Sheet 1
Column 1 = Names
Column 2 = Types of industry
Column 3 = Rating

Sheet 2
Column 1 = Names filtered by rating in Sheet 1


now how do i do a count of the number of names in col 1 of sheet 2 according
to the various types on industries in col 2 of sheet 1?

so i will list the various industries in sheet 2. how do i put a count in
the cell next to each category of the names in col 1 of sheet 2?

hope i'm making sense here and you could help. thanks!