Hi all,

I need help with an employee database request. I have three columns of data: employee ID, job number/classification, and job title. In my organization, job titles can tie to one job number, or several. Example: all Accountant I's within our organization have the same job number, because they do the same job. Engineer I's can have different job numbers, for the different jobs Engineer I's can do (Software Engineers I, Database Engineers I, etc.). An example of job number is 546459 - they are quite long.

I have a list of all employees IDs (unique for all employees), and their corresponding job numbers and job titles. What I want is a list of how many instances of different job numbers correspond to each job title. To take the example above, Accountant I would have one job number, because all Accountant I's have the same job number. Engineer I would have 25 or so job numbers, because we have a whole lot of Engineer I's.

Pivot table doesn't seem to be able to do this, as it counts the number of individuals in a job number, rather than the number of job numbers that would correspond to a title.

The lay out of the spreadsheet is:

Emploee ID | Job Title | Job Classificatiom
001 | Accountant I | 1234
002 | Accountant I | 1234
003 | Engineer I | 2223
004 | Engineer I | 8888

Any help is much appreciated as always!