I have two columns. One column contains the names of the people working in an organization. The second column contains the people's functions within the org:
NAME-----------JOB
Joe-----------Analyst
Jim-----------Manager
Mary----------Secretary
Jackie--------Manager
Christie------Analyst
What I want to achieve is the following:
Analysts:---2
Managers:---2
Secretary:--1
Which function or formula do I need to use in order to be able to count how many manager, analyst, and secretary are in the JOB column. Can someone help me out?
Thanks a lot
This message was edited by hoz on 2002-04-09 05:04
NAME-----------JOB
Joe-----------Analyst
Jim-----------Manager
Mary----------Secretary
Jackie--------Manager
Christie------Analyst
What I want to achieve is the following:
Analysts:---2
Managers:---2
Secretary:--1
Which function or formula do I need to use in order to be able to count how many manager, analyst, and secretary are in the JOB column. Can someone help me out?
Thanks a lot
This message was edited by hoz on 2002-04-09 05:04