se7098 wrote:
Thanks for the suggestion Glenn, however, my manager wants to see the results
within the same worksheet.



If the other solution offered doesn't work for you, then consider using
subtotals (at each change in "Job Title", use function "Count" and add subtotal
to "Job Title").