Counting different categories of data

bh24524

Active Member
Joined
Dec 11, 2008
Messages
256
Office Version
  1. 2013
  2. 2007
I have a set of employment termination categories that I need to be able to have a count of every time one of them is used. Here is the key:

Termination Code Description
ATN Attendance
COC Violation of Code of Conduct
DEA Death
FPC Failed Pre-Employment Check
JOB Job Abandonment
LVE Failure to Return from Leave
NI9 No I9 within 3 days of hire
RAT Retired
TAR Tardiness
TIH Taleo Invalid Hire
TRS Temporary Assignment/Return to School
UNS Unsatisfactory Performance
VCA Career Advancement
VHR Voluntary - Hours
CVIO Violation of Company Policy
VLD Voluntary - Leadership
VMU Mutual Separation
VPY Voluntary - Pay
VSP Voluntary Separation Program
VUN Voluntary - Unknown/Other
VPD Voluntary - Physicality of Job
PRI Part Time Reduction in Force

On a separate tab, it has several columns, the most important being the employee name and the the reason for termination. My question is for counting each of these codes used, would the best way be to use a Pivot Table or is there something different that could be used?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,256
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
have toy tried the =countif() function?
 

bh24524

Active Member
Joined
Dec 11, 2008
Messages
256
Office Version
  1. 2013
  2. 2007
Yeah and I ran it by the employee. That will be good enough for him to use. I was thinking he would need more than just that type of data, but it turns out this is all he needs so I think a Pivot table would be overkill.
 

Forum statistics

Threads
1,147,731
Messages
5,742,852
Members
423,758
Latest member
accountfornada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top